Home » RDBMS Server » Server Utilities » export datapump issue (10g Enterprise Edition Solaris 10)
export datapump issue [message #351240] Tue, 30 September 2008 01:15 Go to next message
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 #351247 is a reply to message #351240] Tue, 30 September 2008 01:38 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Quote:
"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


You can try SCHMEA or Table level export it's should work. But your trying FULL export. DBA privilge should be needed for this export.

Try this..

http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_export.htm#i1006790

Babu
Re: export datapump issue [message #505032 is a reply to message #351240] Thu, 28 April 2011 21:58 Go to previous messageGo to next message
mzainal
Messages: 54
Registered: March 2010
Location: Malaysia
Member
I had similar problem. But i'm using system. Any idea how to solve it?

My database is oracle 10.2.0.4 64bit.
Re: export datapump issue [message #505055 is a reply to message #505032] Fri, 29 April 2011 00:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ From which database version to which database version? OS? ...
2/ Did you try what Babu suggested?

Regards
Michel
Re: export datapump issue [message #569783 is a reply to message #351240] Thu, 01 November 2012 08:39 Go to previous messageGo to next message
sudheergodgeri
Messages: 7
Registered: December 2010
Location: Mumbai, India
Junior Member

No need for bothering with rights here.

The message ANONYMOUS BLOCK means that there is some object defined in dictionary like
tablespace/datafile/tempfile etc. for which the physical object is missing/ accidentally deleted.
Check for presence of temporary files ( since offline/missing temp files are not flaggd in alert logs)
- drop / recreate the same if necessary using DROP TABLESPACE (temptablespacename);
and then recreate it using fresh tempfile spceification.
Then retry the EXPDP using fULL=YES and content=metadata_only -- if this does not thrown an error, most
probably you will not get error in full actual export as well..

The above is how i solved my issue in a production database on red hat linux with oracle 10g ent edition.

Re: export datapump issue [message #569789 is a reply to message #569783] Thu, 01 November 2012 11:19 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Error while importing a dump file in Oracle 10g R1
Next Topic: migration from Sybase to oracle 1 table fails with SQL Error: ORA-01841: (full) year must be between
Goto Forum:
  


Current Time: Thu Mar 28 12:54:32 CDT 2024