OraFAQ Forum: Server Utilities » Fatal error in data pump import

Home » RDBMS Server » Server Utilities » Fatal error in data pump import

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Fatal error in data pump import [message #219659]

Thu, 15 February 2007 06:02

kukreja
Messages: 33
Registered: February 2007

Member

Hi

I am new in Oracle Technology. Please help me solving this error
As i put data pump import command

got the error..........

Import: Release 10.1.0.2.0 - Production on Thursday, 15 February, 2007 3:54

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
Master table "SYSTEM"."SYS_SQL_FILE_FULL_02" successfully loaded/unloaded
Starting "SYSTEM"."SYS_SQL_FILE_FULL_02": system/******** directory=data_pump dumpfile=prashant_dp.
dmp SQLFILE=prashant_imp.sql logfile=prashant_imp.log
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS while calling DBMS_METADATA.CONVERT
[]
ORA-06502: PL/SQL: numeric or value error
LPX-00210: expected '<' instead of 'n'

----- PL/SQL Call Stack -----
object line object
handle number name
0x540a0b7c 13460 package body SYS.KUPW$WORKER
0x540a0b7c 5810 package body SYS.KUPW$WORKER
0x540a0b7c 11153 package body SYS.KUPW$WORKER
0x540a0b7c 2891 package body SYS.KUPW$WORKER
0x540a0b7c 3530 package body SYS.KUPW$WORKER
0x540a0b7c 6395 package body SYS.KUPW$WORKER
0x540a0b7c 1208 package body SYS.KUPW$WORKER
0x534beb10 2 anonymous block

Job "SYSTEM"."SYS_SQL_FILE_FULL_02" stopped due to fatal error at 03:54

Report message to a moderator

Re: Fatal error in data pump import [message #219662 is a reply to message #219659]

Thu, 15 February 2007 06:11

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

ORA-39125:
Worker unexpected fatal error in string while calling string [string]

Cause:
An unhandled exception was detected internally within the worker process for the Data Pump job while calling the specified external routine. This is an internal error. Additional information may be supplied.

Action:
If problem persists, contact Oracle Customer Support.

Report message to a moderator

Re: Fatal error in data pump import [message #219678 is a reply to message #219659]

Thu, 15 February 2007 07:20

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

This is related to XSL. Run initmeta.sql logged in as sys (talk to your DBA) and try again.

Report message to a moderator

Re: Fatal error in data pump import [message #219687 is a reply to message #219678]

Thu, 15 February 2007 09:35

kukreja
Messages: 33
Registered: February 2007

Member

thanks a lot it works

Report message to a moderator

Re: Fatal error in data pump import [message #586499 is a reply to message #219678]

Fri, 07 June 2013 02:00

mariappanvijayan
Messages: 10
Registered: May 2013

Junior Member

hi,

how to run this xsl run initmeta.sql .
Please tell me

i logind as sys .

its throwing the error

SQL> @initmeta.sql
BEGIN SYS.DBMS_METADATA_UTIL.LOAD_STYLESHEETS('/apps/11g/product/11.1.0/db_1/rdbms/xml/xsl'); END;

*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'LOAD_STYLESHEETS'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Report message to a moderator