Home » RDBMS Server » Server Utilities » Fatal error in data pump import
Fatal error in data pump import [message #219659] Thu, 15 February 2007 06:02 Go to next message
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
Re: Fatal error in data pump import [message #219662 is a reply to message #219659] Thu, 15 February 2007 06:11 Go to previous messageGo to next message
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.
Re: Fatal error in data pump import [message #219678 is a reply to message #219659] Thu, 15 February 2007 07:20 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10615
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.
Re: Fatal error in data pump import [message #219687 is a reply to message #219678] Thu, 15 February 2007 09:35 Go to previous messageGo to next message
kukreja
Messages: 33
Registered: February 2007
Member
thanks a lot it works
Re: Fatal error in data pump import [message #586499 is a reply to message #219678] Fri, 07 June 2013 02:00 Go to previous messageGo to next message
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
Re: Fatal error in data pump import [message #586511 is a reply to message #586499] Fri, 07 June 2013 03:01 Go to previous messageGo to next message
Michel Cadot
Messages: 58833
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Are you executing the script for your version (you didn't post as you should)?

Regards
Michel
Re: Fatal error in data pump import [message #586524 is a reply to message #586511] Fri, 07 June 2013 03:42 Go to previous messageGo to next message
mariappanvijayan
Messages: 10
Registered: May 2013
Junior Member
wt i ve to do then....guide me..cme to gtalk ..mariappanvijayan@gmail.com
Re: Fatal error in data pump import [message #586530 is a reply to message #586524] Fri, 07 June 2013 04:25 Go to previous messageGo to next message
Littlefoot
Messages: 19465
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Please, use plain English language when communicating on OraFAQ Forum.
Re: Fatal error in data pump import [message #586582 is a reply to message #586524] Fri, 07 June 2013 10:32 Go to previous message
Michel Cadot
Messages: 58833
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And post the answer to my question.

Regards
Michel
Previous Topic: Job "SYSTEM"."SYS_IMPORT_SCHEMA_05" stopped due to fatal error
Next Topic: SQL Loader - High Volume of Date
Goto Forum:
  


Current Time: Wed Aug 20 02:17:54 CDT 2014

Total time taken to generate the page: 0.09382 seconds