OraFAQ Forum: Server Utilities » Oracle Data Pump import error.

Home » RDBMS Server » Server Utilities » Oracle Data Pump import error. (Oracle 10g, Windows, 4 GB RAM.)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Data Pump import error. [message #467566]

Mon, 26 July 2010 01:43

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

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Oracle Data Pump import error. [message #467581 is a reply to message #467573]

Mon, 26 July 2010 02:33

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

Report message to a moderator

Re: Oracle Data Pump import error. [message #467592 is a reply to message #467581]

Mon, 26 July 2010 03:08

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Maybe you hit a limit of Windows standard edition which is a 32-bit OS (afaik).

Regards
Michel

Report message to a moderator

Re: Oracle Data Pump import error. [message #467600 is a reply to message #467592]

Mon, 26 July 2010 03:38

burasami
Messages: 20
Registered: April 2010

Junior Member

Hi Michel,

Please give some hint to over come this issue.

Thanks & Regards
Burasami

Report message to a moderator

Re: Oracle Data Pump import error. [message #467605 is a reply to message #467600]

Mon, 26 July 2010 03:46

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 11 06:14:46 CST 2025