OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Exp / Imp (10.2.0 , oel 4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Exp / Imp [message #563313]

Sun, 12 August 2012 09:58

thiyagusham
Messages: 112
Registered: April 2012
Location: Chennai

Senior Member

hai

In our group we have some different thoughts.I mean Direct path vs Conventinal path


1)Both parameters fetching data from disc  into buffer cache. am i right ??

2) Direct path skips SQL BUFFER i mean (EVALUATION BUFFER) am i right ??

If so , 

3)purpose of evaluation buffer is it checking username /password ????

4) sql buffer , is it evaluation buffer ??

Thanks and Regards
Thiyagu.G

Report message to a moderator

Re: Exp / Imp [message #563314 is a reply to message #563313]

Sun, 12 August 2012 10:06

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

when all else fails Read The Fine Manual via URL below

http://docs.oracle.com/cd/B19306_01/server.102/b14215/index.htm

read all 52 occurrences for "direct path"

Report message to a moderator

Re: Exp / Imp [message #563316 is a reply to message #563314]

Sun, 12 August 2012 11:02

thiyagusham
Messages: 112
Registered: April 2012
Location: Chennai

Senior Member

@ blackswan

I got my answer ... but some clarity for only one question

1 .Evaluation buffer what it does actually ???

Thanks and Regards
thiyagusham .G

Report message to a moderator

Re: Exp / Imp [message #563317 is a reply to message #563316]

Sun, 12 August 2012 11:11

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>1 .Evaluation buffer what it does actually ???
If you do not understand words previously written in the Fine Manual above,
why should I waste my time writing same words here ( & have you not understand them here)?

How will your behavior change after you understand what evaluation buffer does?

Report message to a moderator

Re: Exp / Imp [message #563318 is a reply to message #563317]

Sun, 12 August 2012 12:46

thiyagusham
Messages: 112
Registered: April 2012
Location: Chennai

Senior Member

@ hai

Again few doubts please clarify

1. Import using the buffer cache? - if so , how can i check ?? IS there any specific options ??

Thanks and Regards
Thiyagusham. G

Report message to a moderator

Re: Exp / Imp [message #563319 is a reply to message #563318]

Sun, 12 August 2012 12:52

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

if you don't answer our questions to you, why should we answer your questions.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

realize that exp & imp are obsoleted & have been replaced by expdp & impdp

[Updated on: Sun, 12 August 2012 12:54]

Report message to a moderator

Previous Topic:	EXTERNAL TABLE PROBLEM
Next Topic:	Getting errors during importing data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 22:05:08 CST 2025