import errors
792290Oct 5 2010 — edited Oct 6 2010Hello,
I am trying to import from a shcema few tables and i get the following errors. i tried to increase the PGA, streams pool size etc as per the suggestions when i googled on the errors. But nothing did not work. Please help me out, it s so frustating after i spend about 3 hours googling and implementing those...
I ma pasting the errors:
Import: Release 10.2.0.4.0 - Production on Tuesday, 05 October, 2010 11:18:58
Copyright (c) 2003, 2007, Oracle. All rights reserved.
;;;
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYSTEM"."TESTIMP" successfully loaded/unloaded
Starting "SYSTEM"."TESTIMP": system/********@TEST parfile=testimp.par
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
ORA-39065: unexpected master process exception in KUPC$QUEUE_INT.PUT_STATUS
ORA-04030: out of process memory when trying to allocate 4096 bytes (PLS non-lib hp,pdzdM80_Allocate_Block)
ORA-01423: error encountered while checking for extra rows in exact fetch
ORA-04030: out of process memory when trying to allocate 16396 bytes (QERHJ hash-joi,QERHJ Bit vector)
ORA-39097: Data Pump job encountered unexpected error -4030
ORA-39065: unexpected master process exception in MAIN
ORA-04030: out of process memory when trying to allocate 4096 bytes (PLS non-lib hp,pdzdM80_Allocate_Block)
ORA-06512: at "SYS.KUPM$MCP", line 11622
ORA-06512: at "SYS.KUPM$MCP", line 11543
ORA-06512: at "SYS.KUPM$MCP", line 11361
ORA-06512: at "SYS.KUPM$MCP", line 1140
ORA-01423: error encountered while checking for extra rows in exact fetch
ORA-04030: out of process memory when trying to allocate 16396 bytes (QERHJ hash-joi,QERHJ Bit vector)
Job "SYSTEM"."TESTIMP" stopped due to fatal error at 11:20:25
please help.
Thanks a lot...