Home » RDBMS Server » Server Utilities » expdp -Error:Job "DBA_UTIL"."SYS_EXPORT_SCHEMA_08" stopped due to fatal error (Oracle ,11gR2,Windows)
expdp -Error:Job "DBA_UTIL"."SYS_EXPORT_SCHEMA_08" stopped due to fatal error [message #523032] Thu, 15 September 2011 04:43 Go to next message
prejib
Messages: 126
Registered: March 2009
Location: India
Senior Member
While doing the data export using datapump utility I am getting the below error. I have increased the size of tablespace - users . Still getting the same error.
C:\Documents and Settings\pressy>expdp dumpfile=expdp_linux.dmp logfile=expdp_linux.log directory=DATA_PUMP_DIR schemas=
linux_CATA EXCLUDE=STATISTICS  compression=all

Export: Release 11.2.0.1.0 - Production on Thu Sep 15 15:11:14 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Username: dba_util/*******@orcl
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "DBA_UTIL"."SYS_EXPORT_SCHEMA_08":  dba_util/********@orcl dumpfile=expdp_linux.dmp logfile=expdp_linux.log
 directory=DATA_PUMP_DIR schemas=linux_CATA EXCLUDE=STATISTICS compression=all
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 89.18 MB
Processing object type SCHEMA_EXPORT/USER
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW00" prematurely terminated
ORA-31671: Worker process DW00 had an unhandled exception.
ORA-04030: out of process memory when trying to allocate 2097164 bytes (pga heap,zbits_kgcbz2state)
ORA-06512: at "SYS.KUPW$WORKER", line 1712
ORA-06512: at line 2

Processing object type SCHEMA_EXPORT/USER
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 2 with process name "DW00" prematurely terminated
ORA-31671: Worker process DW00 had an unhandled exception.
ORA-04030: out of process memory when trying to allocate 2097164 bytes (pga heap,zbits_kgcbz2state)
ORA-06512: at "SYS.KUPW$WORKER", line 1712
ORA-06512: at line 2

Job "DBA_UTIL"."SYS_EXPORT_SCHEMA_08" stopped due to fatal error at 15:09:43
Re: expdp -Error:Job "DBA_UTIL"."SYS_EXPORT_SCHEMA_08" stopped due to fatal erro [message #523033 is a reply to message #523032] Thu, 15 September 2011 05:08 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
ORA-04030: Out of process memory when trying to allocate string bytes (string,string)
Cause:  Operating system process private memory has been exhausted
Action: none


Windows doesn't have enough RAM available.


Re: expdp -Error:Job "DBA_UTIL"."SYS_EXPORT_SCHEMA_08" stopped due to fatal erro [message #523037 is a reply to message #523033] Thu, 15 September 2011 06:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In the meantime, decrease the parallelism.

Regards
Michel
Re: expdp -Error:Job "DBA_UTIL"."SYS_EXPORT_SCHEMA_08" stopped due to fatal erro [message #523182 is a reply to message #523037] Thu, 15 September 2011 22:32 Go to previous message
prejib
Messages: 126
Registered: March 2009
Location: India
Senior Member
Thanks !!!
Previous Topic: Data Pump
Next Topic: interactive-command mode Vs logging mode
Goto Forum:
  


Current Time: Fri Mar 29 02:30:57 CDT 2024