Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

expdp dmp file size is in MB where in impdp it is in GB...

user12115Jul 10 2012 — edited Jul 10 2012

Hi All,

I have a question related to expdp and impdp with 11g database. I have taken one schema's expdp and the size is of the dmp file is 213Mb and the same schema I have imported in another database machine different database (same 11g version) and the space occupied by schema's tablespace is in GB - 210GB. There is no change in the db_block size in any of the database.

I am sure anyone of you must face the similar issue. Can you please guide me why this big difference in expdp and impdp users size.

FYR- I used below syntax for expdp and impdp

expdp system/********@test schemas=JISP dumpfile=JISP.DMP logfile=JISP.log directory=dump content=all version=10.2.0.4

impdp system/*******@test1 schemas=JISP dumpfile=JISP.DMP logfile=JISP_imp.log directory=dump content=all transform=OID:n remap_schema=JSIP:JISP7 remap_tablespace=USERS:DATA7

Thanks in advance...

Edited by: user12115 on Jul 10, 2012 12:42 AM