Home » RDBMS Server » Server Utilities » impdp in linux ..help in this
impdp in linux ..help in this [message #586500] Fri, 07 June 2013 02:02 Go to next message
mariappanvijayan
Messages: 10
Registered: May 2013
Junior Member
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [TABLE_STATISTICS]
ORA-06502: PL/SQL: numeric or value error
LPX-00225: end-element tag "COL_STATS_ITEM" does not match start-element tag "COL_STATS"

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 7839

-- PL/SQL Call Stack --
object line object
handle number name
3acdf1c68 18237 package body SYS.KUPW$WORKER
3acdf1c68 7866 package body SYS.KUPW$WORKER
3acdf1c68 15147 package body SYS.KUPW$WORKER
3acdf1c68 3792 package body SYS.KUPW$WORKER
3acdf1c68 8532 package body SYS.KUPW$WORKER
3acd5b510 1 anonymous block
3ae12d930 1575 package body SYS.DBMS_SQL
3acdf1c68 8342 package body SYS.KUPW$WORKER
3acdf1c68 1545 package body SYS.KUPW$WORKER
3acdf3ca0 2 anonymous block

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [TABLE_STATISTICS]
ORA-06502: PL/SQL: numeric or value error
LPX-00225: end-element tag "COL_STATS_ITEM" does not match start-element tag "COL_STATS"

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 7839

-- PL/SQL Call Stack --
object line object
handle number name
3acdf1c68 18237 package body SYS.KUPW$WORKER
3acdf1c68 7866 package body SYS.KUPW$WORKER
3acdf1c68 15147 package body SYS.KUPW$WORKER
3acdf1c68 3792 package body SYS.KUPW$WORKER
3acdf1c68 8532 package body SYS.KUPW$WORKER
3b2278490 1 anonymous block
3ae12d930 1575 package body SYS.DBMS_SQL
3acdf1c68 8342 package body SYS.KUPW$WORKER
3acdf1c68 1545 package body SYS.KUPW$WORKER
3acdf3ca0 2 anonymous block

Job "SYS"."SYS_IMPORT_FULL_02″ stopped due to fatal error at 19:48:10
Re: impdp in linux ..help in this [message #586502 is a reply to message #586500] Fri, 07 June 2013 02:08 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What are you importing, using what?

I mean:
- source database version is?
- target database version is?
- export was done using EXPDP version?
- import is done using IMPDP version?
Re: impdp in linux ..help in this [message #586504 is a reply to message #586502] Fri, 07 June 2013 02:10 Go to previous messageGo to next message
mariappanvijayan
Messages: 10
Registered: May 2013
Junior Member
oracle11g

i used this comand
impdp directory=EXP_DIR dumpfile=aa_af_av_3703.dmp sqlfile=nkumar_1_3703.sql
Re: impdp in linux ..help in this [message #586509 is a reply to message #586504] Fri, 07 June 2013 02:58 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
You haven't answered all the questions.
Plus there are multiple versions of 11g - which precise one are you using?
Re: impdp in linux ..help in this [message #592376 is a reply to message #586509] Wed, 07 August 2013 05:39 Go to previous messageGo to next message
8939513598$
Messages: 103
Registered: July 2013
Location: chennai
Senior Member
first assign a non-system tablespace and new temporary tablespace to the source user, and while importing to the target schema using impdp , the parameter TABLE_EXISTS_ACTION=SKIP/APPEND/TRUNCATE/REPLACE should be used.., to avoid fatal error,
Re: impdp in linux ..help in this [message #592379 is a reply to message #586504] Wed, 07 August 2013 05:43 Go to previous messageGo to next message
8939513598$
Messages: 103
Registered: July 2013
Location: chennai
Senior Member
Hi, this is just you were going to read the DDL description contents in a dumpfile when using the parameter SQLFILE along with impdp.
Re: impdp in linux ..help in this [message #592380 is a reply to message #592376] Wed, 07 August 2013 05:43 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What does this have to do with the problem and question?
Do you randomly answer to the questions?

Regards
Michel
Previous Topic: User creation while impdp
Next Topic: INCLUDE=TABLE:"IN (select name from maintenance.tt)" does not work
Goto Forum:
  


Current Time: Thu Mar 28 03:00:49 CDT 2024