OraFAQ Forum: Server Administration » oracle error while taking export of the database

Home » RDBMS Server » Server Administration » oracle error while taking export of the database

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

oracle error while taking export of the database [message #151374]

Wed, 14 December 2005 08:45

kirdha1
Messages: 18
Registered: July 2005

Junior Member

I got the folloing error while takeing full export of the database. and export was termianted with err.

EXP-00056: ORACLE error 604 encountered
ORA-00604: error occurred at recursive SQL level 2
ORA-04031: unable to allocate 4200 bytes of shared memory ("shared pool","TRIGGER$","sga heap","state objects")
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 4200 bytes of shared memory ("shared pool","unknown object","sga heap","state objects")
Username:
EXP-00030: Unexpected End-Of-File encountered while reading input
EXP-00000: Export terminated unsuccessfully

parameters of the export file

recordlength=65535
direct=y
full=y
statistics=none
compress=n
consistent=y

Can you pl. give any sugesstions for above problem ?

Report message to a moderator

Re: oracle error while taking export of the database [message #151375 is a reply to message #151374]

Wed, 14 December 2005 08:51

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

What is your JAVA_POOL_SIZE?
If it is too low, try increasing it.

Report message to a moderator

Re: oracle error while taking export of the database [message #151385 is a reply to message #151375]

Wed, 14 December 2005 10:07

kirdha1
Messages: 18
Registered: July 2005

Junior Member

sorry but i could not understand how java_pool_size will resolve the issue . I think I have already mentioned that I am getting this error while taking export using direct=Y .

It may work but i need to give proper explaination to client .

Report message to a moderator

Re: oracle error while taking export of the database [message #151392 is a reply to message #151385]

Wed, 14 December 2005 10:37

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

i said,
>> try increasing .
Never said, it WILL FIX anything.
Your export session is running out of memory.
If this is a reproducible case, increasing JAVA_POOL_SIZE and SHARED_POOL_SIZE (which will result in increased SGA) might help.
If this not a reproducible case, just bouncing the database might also help.
Also
>>recordlength=65535
did you do the math before using this?
>> I think I have already mentioned that I am getting this error while taking export using direct=Y .
What is the relevance here?

Report message to a moderator

Re: oracle error while taking export of the database [message #151517 is a reply to message #151392]

Thu, 15 December 2005 04:49

kirdha1
Messages: 18
Registered: July 2005

Junior Member

hey Actually you had just told to increase java_pool_size .
But no explaination was there.
Thats y I took it in other way .

Thanks for the information and clarifying some of our concepts too .

Report message to a moderator

Previous Topic:	Import to another tablespace oracle10G
Next Topic:	Using DBMS_METADATA API's

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 16:56:44 CST 2025