expdp -Error:Job "DBA_UTIL"."SYS_EXPORT_SCHEMA_08" stopped due to fatal error [message #523032] |
Thu, 15 September 2011 04:43  |
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
|
|
|
|
|
|