Home » RDBMS Server » Server Utilities » Data Pump
Data Pump [message #228045] Fri, 30 March 2007 23:47 Go to next message
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 #228046 is a reply to message #228045] Fri, 30 March 2007 23:52 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

HI,
http://www.oracle.com/technology/pub/notes/technote_pump_restart.html


hope this helps
Taj
Re: Data Pump [message #228084 is a reply to message #228045] Sat, 31 March 2007 06:31 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> The file where am taking the dump has 350GB
Are you sure?
>>FILESIZE=32212254720
Check this.
Re: Data Pump [message #503997 is a reply to message #228084] Wed, 20 April 2011 17:03 Go to previous messageGo to next message
amandabalceskis
Messages: 1
Registered: April 2011
Location: São Paulo
Junior Member

Do you need to remove the parallel and try again.

Amanda Balceskis
Re: Data Pump [message #504206 is a reply to message #503997] Fri, 22 April 2011 00:56 Go to previous message
ramoradba
Messages: 2454
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
Previous Topic: SQL Loader and Replace Function dont work.
Next Topic: multiple export/import dump files
Goto Forum:
  


Current Time: Mon Dec 05 03:01:38 CST 2016

Total time taken to generate the page: 0.11587 seconds