Home » RDBMS Server » Server Utilities » Data Pump Sys.Kupw$worker error
Data Pump Sys.Kupw$worker error [message #180659] Tue, 04 July 2006 10:39 Go to next message
crosimoto
Messages: 6
Registered: June 2006
Location: Washington DC
Junior Member
I asked if this output makes any sense to anyone. I may be new here but..... Will someone tell me an answer or simply that this doesn't make sense.

********************************ERROR LOG *********************
Export: Release 10.1.0.4.0 - 64bit Production on Thursday, 22 June, 2006 11:53

Copyright (c) 2003, Oracle. All rights reserved.
;;;
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
FLASHBACK automatically enabled to preserve database integrity.
Starting "WRSDB"."SYS_EXPORT_SCHEMA_06": wrsdb/******** DIRECTORY=wsrs_exp DUMPFILE=wrsdb.dmp LOGFILE=wrsdb_file.log SCHEMAS=SRSDB
Estimate in progress using BLOCKS method...

ORA-39125: Worker unexpected fatal error in KUPW$WORKER.GET_TABLE_DATA_OBJECTS while calling DBMS_METADATA.FETCH_XML_CLOB []
ORA-04067: not executed, type body "SYS.XMLTYPE" does not exist
ORA-06508: PL/SQL: could not find program unit being called

----- PL/SQL Call Stack -----

object line object
handle number name

c0000000b3efcd08 13612 package body SYS.KUPW$WORKER
c0000000b3efcd08 5888 package body SYS.KUPW$WORKER
c0000000b3efcd08 8350 package body SYS.KUPW$WORKER
c0000000b3efcd08 1612 package body SYS.KUPW$WORKER
c0000000b3efcd08 6403 package body SYS.KUPW$WORKER
c0000000b3efcd08 1251 package body SYS.KUPW$WORKER
c0000000aeae9018 2 anonymous block

Job "WRSDB"."SYS_EXPORT_SCHEMA_06"
stopped due to fatal error at 11:53

Job SYS_EXPORT_SCHEMA_06 has been reopened at
Thursday, 22 June, 2006 12:20
;;; Export> kill_job

Job "WRSDB"."SYS_EXPORT_SCHEMA_06" stopped
due to fatal error at 12:20
********************** END ERROR LOG ***********************
Re: Data Pump Sys.Kupw$worker error [message #180731 is a reply to message #180659] Wed, 05 July 2006 01:08 Go to previous messageGo to next message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Quote:

ORA-04067: not executed, type body "SYS.XMLTYPE" does not exist


Connect to SYS AS SYSDBA and execute these scripts to create XMLTYPE:

SQL> @?/rdbms/admin/dbmsxmlt.sql
SQL> @?/rdbms/admin/prvtxmlt.plb
Re: Data Pump Sys.Kupw$worker error [message #180855 is a reply to message #180731] Wed, 05 July 2006 09:09 Go to previous message
crosimoto
Messages: 6
Registered: June 2006
Location: Washington DC
Junior Member
Thank you kindly sir.
Previous Topic: how to open the .dmp file
Next Topic: .CSV file to .CTL file
Goto Forum:
  


Current Time: Thu Jul 04 19:44:57 CDT 2024