| export datapump issue [message #351240] |
Tue, 30 September 2008 01:15  |
jesuisantony
Messages: 166
Registered: July 2006
Location: Chennai
|
Senior Member |
|
|
Hi,
We find issues is exporting datapump using a specific ID.
Error Message:
Export: Release 10.2.0.3.0 - 64bit Production on Tuesday, 30 September, 2008 11:39:58
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
FLASHBACK automatically enabled to preserve database integrity.
Starting "EXPDBA"."SYS_EXPORT_FULL_09": test/********@CDOi2 directory=test_pump_dir dumpfile=test-dp-30-Sep-08.dmp logfile=test-dp-30-Sep-08.log full=y
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.GET_TABLE_DATA_OBJECTS while calling DBMS_METADATA.FETCH_XML_CLOB []
ORA-31642: the following SQL statement fails:
BEGIN "SYS"."DBMS_CDC_EXPDP".SCHEMA_CALLOUT(:1,0,1,'10.02.00.03.00'); END;
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_METADATA", line 907
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 6228
----- PL/SQL Call Stack -----
object line object
handle number name
3c91c50f0 14916 package body SYS.KUPW$WORKER
3c91c50f0 6293 package body SYS.KUPW$WORKER
3c91c50f0 9108 package body SYS.KUPW$WORKER
3c91c50f0 1881 package body SYS.KUPW$WORKER
3c91c50f0 6854 package body SYS.KUPW$WORKER
3c91c50f0 1259 package body SYS.KUPW$WORKER
3b0d5b2d0 2 anonymous block
Job "EXPDBA"."SYS_EXPORT_FULL_09" stopped due to fatal error at 11:40:04
The following privs have been granted. And privilege has been granted on the USERS tablespace.
grant create session,exp_full_database,create table to test;
grant execute on "SYS"."DBMS_CDC_EXPDP" to test;
grant execute on SYS.DBMS_SYS_ERROR to test;
grant execute on SYS.DBMS_METADATA to test;
grant execute on SYS.DBMS_SYS_ERROR to test;
grant execute on SYS.KUPW$WORKER to test;
But still the same issue.
When dba privilege is granted to the user the expdp runs successfully.
I dont want to give the dba privs. Pls help in resolving this issue.
[mod-edit] bold removed.
[Updated on: Tue, 30 September 2008 08:31] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
| Re: export datapump issue [message #569789 is a reply to message #569783] |
Thu, 01 November 2012 11:19  |
 |
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
From what do you get that?
Prove your claims!
How does this lead to an "ORA-01031: insufficient privileges" error?
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
