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!

Exporting big schema in oracle

TexasMar 19 2012 — edited Mar 19 2012

Hi there,

Please how do I export an entire schema objects, the tables in this schema are very big. It's a DW environment.

Here is my code:
expdp SCHEMAS=SO_MIG_STG DIRECTORY=DATA_PUMP_DIR DUMPFILE=ALL_SO_MIG_STG_%U.dmp logfile=ALL_SO_MIG_STG.log

I keep getting this error:
ORA-39095: Dump file space has been exhausted: Unable to allocate 8192 bytes

Meanwhile, this chema is one of the biggest in the database.

Thank you.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 16 2012

Added on Mar 19 2012

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

3 comments

491 views