impdp in linux ..help in this [message #586500] |
Fri, 07 June 2013 02:02 |
|
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 #592376 is a reply to message #586509] |
Wed, 07 August 2013 05:39 |
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,
|
|
|
|
|