Home » RDBMS Server » Server Utilities » Export via conventional path v/s direct path (DB:Oracle 9i, Version - 9.2.0.1.0, OS: RHEL 2.1 AS)
Export via conventional path v/s direct path [message #396106] Sat, 04 April 2009 00:00 Go to next message
jimit_shaili
Messages: 237
Registered: June 2006
Location: India, Ahmedabad
Senior Member
Dear Friends

I have a question about data Export via conventional path v/s direct path. I have taken a schema wise export via conventional path with interactive mode. The dmp file generated was 325mb. Then i had take same schema export via direct path with command line parameter options [additional parameter was DIRECT=y].The dmp file generated was 320mb.
So my main question is why there was difference between two dmp files.Is there any possibility that direct path skipping some information.

Regards

Jimit.
Re: Export via conventional path v/s direct path [message #396119 is a reply to message #396106] Sat, 04 April 2009 01:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Is there any possibility the data changed between the 2 exports?

Regards
Michel
Re: Export via conventional path v/s direct path [message #396147 is a reply to message #396119] Sat, 04 April 2009 05:34 Go to previous messageGo to next message
jimit_shaili
Messages: 237
Registered: June 2006
Location: India, Ahmedabad
Senior Member
No, i had taken two exports back to back.But i would like to share one more thing that i added the parameter statistic=none in direct path export. [in my db there were not a single table with gathered stats or estimate stats]
Re: Export via conventional path v/s direct path [message #396164 is a reply to message #396106] Sat, 04 April 2009 08:17 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You have to present us the proof of what you did.
Post the exact command line parameters (from session) and file sizes.
Re: Export via conventional path v/s direct path [message #396170 is a reply to message #396147] Sat, 04 April 2009 09:44 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
jimit_shaili wrote on Sat, 04 April 2009 12:34
No, i had taken two exports back to back.But i would like to share one more thing that i added the parameter statistic=none in direct path export. [in my db there were not a single table with gathered stats or estimate stats]

If you want to compare the 2 exports, you have to give exactly the same options for them.

Regards
Michel

Previous Topic: SQL *Loader - Loading data into multiple tables
Next Topic: Question on IMPDP working with wildcards
Goto Forum:
  


Current Time: Thu Mar 28 19:51:24 CDT 2024