Oracle Database Discussions

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!

Oracle 10g - Data Export

Ali ÇelebiMar 10 2011 — edited Mar 10 2011

Hi all!

We're planning to export large volume of data from Oracle 10G database tables and I'd like to understand the size of the dump/extract file that would be created on Unix Solaris.

- Should we use exp or data pump tool to do the export?
- Are there any options to reduce the size of the dump/extract file using exp/datapump?
- If table data is 200GB, how big would the dump/extract file be?

Many thanks in advance!

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 7 2011

Added on Mar 10 2011

#general-database-discussions

2 comments

275 views