Home » RDBMS Server » Server Utilities » Getting error in data pump export
Getting error in data pump export [message #218409] Thu, 08 February 2007 02:01 Go to next message
kukreja
Messages: 33
Registered: February 2007
Member
Hello
Please guide me in solving the error

To get export of table, i fired this query

$ expdp apps/apps directory=data_dump_dir2 tables=prashant dumpfile=prashant_1.dmp

got the error

Export: Release 10.2.0.2.0 - Production on Wednesday, 07 February, 2007 4:42:54

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_TABLE_01 for user APPS
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 600
ORA-39080: failed to create queues "KUPC$C_1_20070207044254" and "KUPC$S_1_20070207044254" for Data Pump job
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 1580
ORA-04031: unable to allocate 4194320 bytes of shared memory ("streams pool","unknown object","streams pool","fixed allocation callback")[/COLOR]

---
After this i compiled all invalid objects by ultility UTLrp.sql and increase the SGA
and again tried but get same error.
Re: Getting error in data pump export [message #218418 is a reply to message #218409] Thu, 08 February 2007 02:37 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member



Hi
go through below link
and with sys as sysdba user run "@?/rdbms/admin/catqueue.sql"

http://groups.google.com/group/comp.databases.oracle.tools/browse_thread/thread/cd9d28cd7681a686/9f7e536c32341ba1


let us know result.

regards
Taj
Re: Getting error in data pump export [message #218438 is a reply to message #218418] Thu, 08 February 2007 03:51 Go to previous messageGo to next message
kukreja
Messages: 33
Registered: February 2007
Member
Hi

Again after that when i fired the command, got internal error

$ expdp apps/apps directory=data_dump_dir2 tables=prashant dumpfile=prashant_1.dmp

Export: Release 10.2.0.2.0 - Production on Thursday, 08 February, 2007 1:47:37

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
ORA-39006: internal error
ORA-39213: Metadata processing is not available

----

grant read,write on directory data_dump_dir2 to apps already given by sys.
Re: Getting error in data pump export [message #218459 is a reply to message #218409] Thu, 08 February 2007 05:49 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
For the original issue, you need to increase SGA_TARGET and allocate more shared pool.
Now that you have re-run the catqueue.sql, you might have dropped a few links here and there.
If you are using javaoptions/xml/or anyother options in your database (even if it is just installed), login as sysdba and execute initjvm.sql and initxml.sql.
Check for the invalid packages agains.
Fix those packages.
Re: Getting error in data pump export [message #218483 is a reply to message #218438] Thu, 08 February 2007 06:41 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
ORA-39213: Metadata processing is not available

Are you sure you grant READ, WRITE privs ON RIGHT directory.
go through below link some problem solve when create DIRECTORY and GRANT READ or WRITE privs to users.


http://www.orafaq.com/forum/t/63783/0/


regards
Taj
Previous Topic: Can we export/import at runtime
Next Topic: Querying flat files
Goto Forum:
  


Current Time: Wed Dec 07 22:37:07 CST 2016

Total time taken to generate the page: 0.07861 seconds