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 previous 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
 
Read Message
Read Message
Read Message
Read Message
Previous Topic: Data Pump
Next Topic: interactive-command mode Vs logging mode
Goto Forum:
  


Current Time: Fri Apr 19 03:19:56 CDT 2024