Skip to Main Content
Forums

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!

ORA-39095: Dump file space has been exhausted despite using %%U

2806541Jan 22 2015 — edited Jan 22 2015

Hey all,

I got the ora error mentioned when I try to export a schema (roundabout 40GB).

I'm using the following command:

expdp ***/***@server DUMPFILE=***_db_%%U.dmp LOGFILE=****_exp.log SCHEMAS=*** DIRECTORY=DIR_WED JOB_NAME=export_*** REUSE_DUMPFILES=Y FILESIZE=30359738368 EXCLUDE=USER EXCLUDE=SYSTEM_GRANT EXCLUDE=ROLE_GRANT EXCLUDE=DEFAULT_ROLE EXCLUDE=STATISTICS

Thanks in advance for your help.
This post has been answered by faraz-dba on Jan 22 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 19 2015
Added on Jan 22 2015
#database-key-features, #export-import-sql-loader-external-tables
5 comments
2,432 views