| ORA-39125,ORA-31600 during expdp [message #175143] |
Thu, 01 June 2006 00:33  |
cecilialeeus
Messages: 3
Registered: May 2006
Location: newark, ca
|
Junior Member |
|
|
Hi,
Thanks to Frank N's pointer. I was able to make some
more progress, but then run into the following.
Not sure why?
Thanks in advance for your help.
Cecilia
===
SQL> execute sys.dbms_tts.transport_set_check ('o_0', true);
PL/SQL procedure successfully completed.
SQL> select * from sys.transport_set_violations;
no rows selected
SQL> alter tablespace o_0 read only;
Tablespace altered.
SQL> create or replace directory my_dir as '/export/home/oracle';
Directory created.
expdp system/manager directory=my_dir dumpfile=tools.dmp transport_tablespaces=o_0 transport_full_check=y logfile=exp_o.log
Export: Release 10.2.0.1.0 - 64bit Production on Thursday, 01 June, 2006 0:59:25
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, OLAP and Data Mining options
Starting "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01": system/******** directory=my_dir dumpfile=tools.dmp transport_tablespaces=o_0 transport_full_check=y logfile=exp_o.log
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.CONFIGURE_METADATA_UNLOAD while calling DBMS_METADATA.OPEN 10.2.0.0.0 []
ORA-31600: invalid input value TRANSPORTABLE_EXPORT for parameter OBJECT_TYPE in function OPEN
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
46afc6a68 14916 package body SYS.KUPW$WORKER
46afc6a68 6300 package body SYS.KUPW$WORKER
46afc6a68 5077 package body SYS.KUPW$WORKER
46afc6a68 1926 package body SYS.KUPW$WORKER
46afc6a68 6861 package body SYS.KUPW$WORKER
46afc6a68 1262 package body SYS.KUPW$WORKER
4666b4dc8 2 anonymous block
Job "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01" stopped due to fatal error at 00:59:30
|
|
|
|
|
|
|
|
|
|
|
|
| Re: ORA-39125,ORA-31600 during expdp [message #505072 is a reply to message #505070] |
Fri, 29 April 2011 02:42  |
mzainal
Messages: 54
Registered: March 2010
Location: Malaysia
|
Member |
|
|
This error i got:
[oracle@dboracle ~]$ expdp system/bpmksm2011 full=y directory=test_dir dumpfile=unidev-full02.dm
p logfile=unidev-log01.log
Export: Release 10.2.0.4.0 - 64bit Production on Saturday, 27 November, 2010 16:30:30
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_FULL_02": system/******** full=y directory=test_dir dumpfile=unid
ev-full02.dmp logfile=unidev-log01.log
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 21.56 MB
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METAD
ATA.FETCH_XML_CLOB [TABLE_DATA:"SYSMAN"."MGMT_DIROBJ_USERS_HOTLIST"]
ORA-01157: cannot identify/lock data file 203 - see DBWR trace file
ORA-01110: data file 203: '/u03/app/oracle/product/10.2.0/oradata/unidev/TISTEMP01.dbf'
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 6313
----- PL/SQL Call Stack -----
object line object
handle number name
0xde2b7180 15032 package body SYS.KUPW$WORKER
0xde2b7180 6372 package body SYS.KUPW$WORKER
0xde2b7180 2396 package body SYS.KUPW$WORKER
0xde2b7180 6944 package body SYS.KUPW$WORKER
0xde2b7180 1314 package body SYS.KUPW$WORKER
0xde285610 2 anonymous block
Job "SYSTEM"."SYS_EXPORT_FULL_02" stopped due to fatal error at 16:30:40
Try expdp using startup mount now.
[Updated on: Fri, 29 April 2011 03:10] by Moderator Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
