| Data Pump [message #228045] |
Fri, 30 March 2007 23:47  |
caprikar
Messages: 226
Registered: March 2007
|
Senior Member |
|
|
Hi,
I'm taking export dump using expdp of some schema's of total size is 300GB. This is the par file:
DIRECTORY=expdp
FILESIZE=32212254720
DUMPFILE=expdp_schema01.dmp,expdp_schema02.dmp,expdp_schema03.dmp,expdp_schema04.dmp,expdp_schema05.dmp,expdp_schema06.dmp,expdp_sche ma07.dmp,expdp_schema08.dmp,expdp_schema09.dmp,expdp_schema10.dmp,expdp_schema11.dmp,expdp_schema12.dmp,expdp_schema13.dmp,expdp_sche ma14.dmp,expdp_schema15.dmp
LOGFILE=expdp_schema.log
ESTIMATE=STATISTICS
PARALLEL=15
SCHEMAS=(
PTO,
TAPP,
IMG,
GPLUX,
TIFF
)
here one biggest schema size is 250GB and the total size of all the schema's is 300GB. The file where am taking the dump has 350GB space but even then the expdp failed saying
ORA-39095: Dump file space has been exhausted: Unable to allocate 8192 bytes
-I don't understand why it failed and how to restart it and make sure it runs successfully without error.
thanks,
GK
|
|
|
|
|
|
|
|
|
|
| Re: Data Pump [message #504206 is a reply to message #503997] |
Fri, 22 April 2011 00:56  |
 |
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
|
Senior Member |
|
|
Hi..
Welcome to Orafaq Forum.
Its a 4 year old post.
Please read Orafaq guide lines before Posting anything.
Sriram
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
