Compress=Y in Exp and Expdp
591186Oct 8 2007 — edited Oct 8 2007I have been using oracle export/import as well as datapump export/import on a regular basis in building our database environments. I noticed the difference between the normal export and the datapump export.
Export(exp) has the compress=Y/N option whereas i didnt see the option in Datapump.
I was looking at the Documentation and found that
http://download.oracle.com/docs/cd/B14117_01/server.101/b10825/dp_export.htm#i1005864
"A parameter comparable to COMPRESS is not needed. " --This is what described in the documentation.
Does Datapump export does automatic compresssion?
I have tried exporting a table(size-14G) from our Database with "norows" option using normal export and tried Datapump export using Metadata_only option and generated the Sql for the metadata definitions.
The script from the normal export shows the initial extent size of 2g whereas SQLfile from the datapump import shows 260M.
Now,which is the best approach for creating objects while Data movement across Databases.
Please clarify.