| Getting error in data pump export [message #218409] |
Thu, 08 February 2007 02:01  |
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 #218438 is a reply to message #218418] |
Thu, 08 February 2007 03:51  |
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.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
