asked on

Datapump export error ORA-39125

Hi:

I'm doing a full database export using datapump in Oracle 10.2.0. Last time it ran, I got the following message:

Starting "SYS"."MISASTOR_EXPORT":
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_RULE_EXP_RULES".SCHEMA_CALLOUT(:1,0,1,'10.02.00.01.00'); END;
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_METADATA", line 907
ORA-01950: no privileges on tablespace 'TREVLAC'
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 6235
----- PL/SQL Call Stack -----
object line object
handle number name
21AFE878 14916 package body SYS.KUPW$WORKER
21AFE878 6300 package body SYS.KUPW$WORKER
21AFE878 9120 package body SYS.KUPW$WORKER
21AFE878 1880 package body SYS.KUPW$WORKER
21AFE878 6861 package body SYS.KUPW$WORKER
21AFE878 1262 package body SYS.KUPW$WORKER
21B49F18 2 anonymous block
Job "SYS"."MISASTOR_EXPORT" stopped due to fatal error at 15:00:09

Any ideas would I need to look at to determine what would have caused this?

Thanks for your help.

ASKER CERTIFIED SOLUTION

ShazbotOK

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

kiss98770

ASKER

My export job runs as sys so it's running as an admin. Also, I checked the tablespace TREVLAC and it's only at 53%. Would there be another reason why access is being denied?

Thanks for your help.

ShazbotOK

What is this worker process doing (at that code line)?
ORA-06512: at "SYS.KUPW$WORKER", line 6235

kiss98770

ASKER

I'm new to this....but, I'm not sure where I need to look...how do I interpret the package "SYS.KUPW$WORKER"?

Thanks.

ShazbotOK

Sorry I was not specific.. SYS.KUPW$WORKER is a System UserID you need to check the privs to that userid

kiss98770

ASKER

Thanks! It was a permission problem after all. Thanks for your help.