Home » RDBMS Server » Server Administration » Datapump Error
Datapump Error [message #226707] Mon, 26 March 2007 04:48 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member

i am trying to export a schema test by using the following

C:\>expdp system/gateway@orcl schemas=test dumpfile=dir1:test%U.dmp filesize=100k logfile=dir1:mylog.log

Error:
ORA-31694: master table "SYSTEM"."SYS_EXPORT_SCHEMA_02" failed to load/unload
ORA-39095: Dump file space has been exhausted: Unable to allocate 184320 bytes
Job "SYSTEM"."SYS_EXPORT_SCHEMA_02" stopped due to fatal error at 14:16:04


Can anybody help me in this regard?
Re: Datapump Error [message #226709 is a reply to message #226707] Mon, 26 March 2007 04:51 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

The size of your dumpfile is too small..
Re: Datapump Error [message #226723 is a reply to message #226709] Mon, 26 March 2007 05:29 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Small typo in above posting.
I am pretty sure Tahpush meant that size of the dumpfile location is small (running out of diskspace?).
Re: Datapump Error [message #226729 is a reply to message #226723] Mon, 26 March 2007 06:02 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

I am refering to the "filesize = 100k"

Job will fail because the specified dump file size is too small ?

Re: Datapump Error [message #226747 is a reply to message #226729] Mon, 26 March 2007 07:13 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
True. I missed that part.Smile
Re: Datapump Error [message #226748 is a reply to message #226747] Mon, 26 March 2007 07:20 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Wink
Previous Topic: Error while executing Dbms_Stats.GATHER_TABLE_STATS
Next Topic: Transportable tablespace
Goto Forum:
  


Current Time: Sun Dec 11 00:10:53 CST 2016

Total time taken to generate the page: 0.13411 seconds