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: 25037
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"
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: 25037
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?
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: 25037
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:
  


Current Time: Mon Dec 05 11:08:05 CST 2016

Total time taken to generate the page: 0.14467 seconds