Home » RDBMS Server » Server Utilities » Export Schema Error (ORACLE 11G,Linux)
Export Schema Error [message #556085] Thu, 31 May 2012 04:18 Go to next message
chanchu
Messages: 11
Registered: May 2012
Junior Member
when i try to export schema using expdp i got error Like

"
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 6.25 MB
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE

UDE-04031: operation generated ORACLE error 4031
ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","SELECT job_id FROM v$datapum...","SQLA","tmp")
ORA-06512: at "SYS.KUPV$FT_INT", line 2904
ORA-06512: at "SYS.KUPC$QUE_INT", line 572
ORA-25254: time-out in LISTEN while waiting for a message
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3263
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4488
ORA-06512: at line 1

"
HOw to solve this issue?
Re: Export Schema Error [message #556087 is a reply to message #556085] Thu, 31 May 2012 04:24 Go to previous messageGo to next message
Michel Cadot
Messages: 67888
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-04031: unable to allocate %s bytes of shared memory (\"%s\",\"%s\",\"%s\",\"%s\")
 *Cause:  More shared memory is needed than was allocated in the shared
          pool.
 *Action: If the shared pool is out of memory, either use the
          dbms_shared_pool package to pin large packages,
          reduce your use of shared memory, or increase the amount of
          available shared memory by increasing the value of the
          INIT.ORA parameters "shared_pool_reserved_size" and
          "shared_pool_size".
          If the large pool is out of memory, increase the INIT.ORA
          parameter "large_pool_size".

Regards
Michel
Re: Export Schema Error [message #556088 is a reply to message #556087] Thu, 31 May 2012 04:26 Go to previous messageGo to next message
chanchu
Messages: 11
Registered: May 2012
Junior Member
How to increase the amount of Shared Memory?
Re: Export Schema Error [message #556091 is a reply to message #556088] Thu, 31 May 2012 04:47 Go to previous message
Michel Cadot
Messages: 67888
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Ask your DBA to do it.

Regards
Michel
Previous Topic: sql loader error
Next Topic: Migrating from 10g to 11g
Goto Forum:
  


Current Time: Wed Jun 23 19:59:06 CDT 2021