What is ORA-39095 ?
. . exported "XXX"."YYYY" 80.85 KB 12 rows
ORA-39095: Dump file space has been exhausted: Unable to allocate 4096/8192 bytes
Job "XXX"."SYS_EXPORT_SCHEMA_02" stopped due to fatal error at Wed Feb 2 01:08:16 2021 elapsed 0 04:56:30
Answer:
There are two solutions.
1- Increasing the Filesize parameter
2- Changing the dumpfile parameter as %U.dmp in order to create multiple dump files while exporting.
Example: expdp xx/yyyy directory=fx_dir dumpfile=example_%U.dmp logfile=example.log full=y filesize=10G
Notes: Check the schema size before transferring.
Because If a total of 99 dmp files are created and export is not finished, the ORA-39095 error will still be received.
Happy day everyone..
No comments:
Post a Comment