Home » RDBMS Server » Server Utilities » Oracle Data Pump import error. (Oracle 10g, Windows, 4 GB RAM.)
icon8.gif  Oracle Data Pump import error. [message #467566] Mon, 26 July 2010 01:43 Go to next message
burasami
Messages: 20
Registered: April 2010
Junior Member
Hi All,

I am trying to import database dump using the following command
impdp system/xxxx@xxxx schemas=staging 
remap_schema=staging:staging directory=DUMPDIR dumpfile=staging.dmp logfile=impdpstaing.log 
TRANSFORM=SEGMENT_ATTRIBUTES:n


its importing data fine upto some stage after that oracle gives the following error
Processing object type SCHEMA_EXPORT/JAVA_SOURCE/JAVA_SOURCE
ORA-39097: Data Pump job encountered unexpected error -1423
ORA-39065: unexpected master process exception in DISPATCH
ORA-01423: error encountered while checking for extra rows in exact fetch
ORA-04030: out of process memory when trying to allocate 123404 bytes (QERHJ has
h-joi,kllcqas:kllsltba)

ORA-39014: One or more workers have prematurely exited.
Job "SYSTEM"."SYS_IMPORT_SCHEMA_04" stopped due to fatal error at 11:42:03


I though its due to lack of memory, so i have increased pga_aggregate_target=512MB to 600MB still i am getting a same error. i am struggling in this error for past 2 days. Please help out to fix the error.. thanks in advance.

[Updated on: Mon, 26 July 2010 01:57] by Moderator

Report message to a moderator

Re: Oracle Data Pump import error. [message #467573 is a reply to message #467566] Mon, 26 July 2010 02:00 Go to previous messageGo to next message
Michel Cadot
Messages: 59414
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-04030: out of process memory when trying to allocate %s bytes (%s,%s)
 *Cause:  Operating system process private memory has been exhausted
 *Action:

This is an OS issue not an Oracle problem.
Oracle asks some memory to the OS which returns that it can't have it.
Either you reached a system limit for a process memory, either the OS memory is exhausted.

To say more, you have to opost your exact Windows version along with memory sizes (RMA, Swap).

Regards
Michel
Re: Oracle Data Pump import error. [message #467581 is a reply to message #467573] Mon, 26 July 2010 02:33 Go to previous messageGo to next message
burasami
Messages: 20
Registered: April 2010
Junior Member
Hi Michel,

Thanks for your quick reply.
I have installed oracle standard edition in
Microsoft windows Server 2003 R2,
standard Edition
Service Pack 2

Intel(R) Xeon CPU 3.00GHz,
4 GB RAM
SWAP MEM: 4106 MB
Re: Oracle Data Pump import error. [message #467592 is a reply to message #467581] Mon, 26 July 2010 03:08 Go to previous messageGo to next message
Michel Cadot
Messages: 59414
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe you hit a limit of Windows standard edition which is a 32-bit OS (afaik).

Regards
Michel
Re: Oracle Data Pump import error. [message #467600 is a reply to message #467592] Mon, 26 July 2010 03:38 Go to previous messageGo to next message
burasami
Messages: 20
Registered: April 2010
Junior Member
Hi Michel,

Please give some hint to over come this issue.

Thanks & Regards
Burasami
Re: Oracle Data Pump import error. [message #467605 is a reply to message #467600] Mon, 26 July 2010 03:46 Go to previous message
Michel Cadot
Messages: 59414
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Export less.
Change to a 64-bit OS.
Open a SR to Oracle.

Regards
Michel

[Updated on: Mon, 26 July 2010 03:46]

Report message to a moderator

Previous Topic: import error --- please solve this
Next Topic: CONCATENATE A DATE WITH SQL LOADER FROM THREE FIELDS
Goto Forum:
  


Current Time: Tue Oct 21 19:32:28 CDT 2014

Total time taken to generate the page: 0.15713 seconds