Home » RDBMS Server » Server Utilities » expdp -export error when using data pump- need help
expdp -export error when using data pump- need help [message #194861] Mon, 25 September 2006 14:50 Go to next message
pzlj6x
Messages: 107
Registered: May 2005
Location: Louisville
Senior Member
I am getting the following error while doing the data pump export using expdp command.

xport: Release 10.2.0.1.0 - 64bit Production on Monday, 25 September, 2006 13:2
1:16

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit
Production
With the Partitioning and Data Mining options
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_TABLE_01 for user TESt
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_20060925132119" and "KUPC$S_1_20060
925132119" for Data Pump job
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 1555
ORA-04031: unable to allocate 4194344 bytes of shared memory ("streams pool","un
known object","streams pool","fixed allocation callback")

user TEST has got DBA role and it has all required privlege to do the export/import.

Please guide me as to what could be the issue and how do I need to fix it.
Thanks




Re: expdp -export error when using data pump- need help [message #195017 is a reply to message #194861] Tue, 26 September 2006 10:16 Go to previous messageGo to next message
pzlj6x
Messages: 107
Registered: May 2005
Location: Louisville
Senior Member


I researched and read some documentation and find the below solution

made changes in init.ora file

Added sga_target = 250 MB
Commented out db_cache_size,
shared_pool_size,
large_pool_size.

It worked fine in my case.

the below document was useful and may be useful for other readers on this forum as well.

http://www.oracle.com/technology/pub/articles/10gdba/week17_10gdba.html

Thanks
icon14.gif  Re: expdp -export error when using data pump- need help [message #195031 is a reply to message #195017] Tue, 26 September 2006 12:16 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> I researched and read some documentation and find the below solution
Cool.
First post of its kind after really a long while.
Smile
Re: expdp -export error when using data pump- need help [message #195440 is a reply to message #194861] Thu, 28 September 2006 11:33 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi
Try

First grant explicit "create table" privs to "test user"
if problem persists then grant "resource" privs to "test" user.

ur not post ur expdp scripts i hope u add "directory" clause in ur scripts.

thanx
Previous Topic: Can find my change from digging archive log with logmnr
Next Topic: SQLLDR with Date column
Goto Forum:
  


Current Time: Thu Dec 12 09:03:17 CST 2024