Home » RDBMS Server » Server Utilities » Exp / Imp (10.2.0 , oel 4)
Exp / Imp [message #563313] Sun, 12 August 2012 09:58 Go to next message
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

Re: Exp / Imp [message #563314 is a reply to message #563313] Sun, 12 August 2012 10:06 Go to previous messageGo to next message
BlackSwan
Messages: 23048
Registered: January 2009
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"
Re: Exp / Imp [message #563316 is a reply to message #563314] Sun, 12 August 2012 11:02 Go to previous messageGo to next message
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
Re: Exp / Imp [message #563317 is a reply to message #563316] Sun, 12 August 2012 11:11 Go to previous messageGo to next message
BlackSwan
Messages: 23048
Registered: January 2009
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?
Re: Exp / Imp [message #563318 is a reply to message #563317] Sun, 12 August 2012 12:46 Go to previous messageGo to next message
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


Re: Exp / Imp [message #563319 is a reply to message #563318] Sun, 12 August 2012 12:52 Go to previous message
BlackSwan
Messages: 23048
Registered: January 2009
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:
  


Current Time: Tue Nov 25 17:12:15 CST 2014

Total time taken to generate the page: 0.09595 seconds