Solved

Datapump export error ORA-39125

Posted on 2007-03-26
6
4,187 Views
Last Modified: 2013-12-19
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.
0
Comment
Question by:kiss98770
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 12

Accepted Solution

by:
ShazbotOK earned 500 total points
ID: 18792905
The worker process that is running this job does not have sufficiant permissions to run - specifically the TREVLAC table is denied access.   Try running the job as a admin and see if the error duplicates - if it does you may be out of space for that partition space.

If it does not - that would confirm the suspect permission issue.
0
 

Author Comment

by:kiss98770
ID: 18793537
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.
0
 
LVL 12

Expert Comment

by:ShazbotOK
ID: 18793558
What is this worker process doing (at that code line)?
ORA-06512: at "SYS.KUPW$WORKER", line 6235
0
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 

Author Comment

by:kiss98770
ID: 18793977
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.
0
 
LVL 12

Expert Comment

by:ShazbotOK
ID: 18794012
Sorry I was not specific.. SYS.KUPW$WORKER is a System UserID you need to check the privs to that userid
0
 

Author Comment

by:kiss98770
ID: 18794984
Thanks!   It was a permission problem after all.   Thanks for your help.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question