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!

Export/import . Difference between source and target schemas.

1028685Jul 27 2013 — edited Jul 29 2013

Hi,

I have small question from the basics which I failed to undertsand. There are two databases which are located on HP-UX 11i servers. Version of both of them is Oracle 11.2.0.3. I need to export schema from one db and import it into second database.

Size of the schema on the source is 400 GB. Export and import operations are successful, all tables are imported. But on the target database size of the schema is 172 GB.

I tried to estimate is there any way to resize schema on the source but stll there is big difference in sizes.

Maybe someone can point into something what I missed. Thank you.

Syntax which I used during exporting and importing (without compression option)

userid=

directory=

dumpfile=

compression=All

parallel=

cluster=n

Best regards,

Vik

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 26 2013

Added on Jul 27 2013

#11g, #database, #database-key-features, #export-import-sql-loader-external-tables, #user

8 comments

1,020 views