Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting an ORA-39126 when importing

752236Feb 8 2010 — edited Feb 8 2010

When i am doing
Connected to: Oracle Database 10g Release 10.2.0.3.0 - Production
Master table "SYSTEM"."SYS_IMPORT_SCHEMA_02" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_SCHEMA_02": system/********@o10g directory=my_imp_dir CONTENT=ALL TABLE_EXISTS_ACTION=REPLACE dumpfile=*****.dmp logfile=my_log_dir:imp.log schemas=e5_database REMAP_TABLESPACE=******:ERGO_USR REMAP_TABLESPACE=*****:ERGO_INDX
Processing object type DATABASE_EXPORT/SCHEMA/USER

i get the following error.

+ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDL [FUNCTION:"E5_DA+
TABASE"."GET_DB_VERSION"]
ORA-44001: invalid schema

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

----- PL/SQL Call Stack -----
object line object
handle number name
+22BD2830 14916 package body SYS.KUPW$WORKER+
+22BD2830 6293 package body SYS.KUPW$WORKER+
+22BD2830 12689 package body SYS.KUPW$WORKER+
+22BD2830 11969 package body SYS.KUPW$WORKER+
+22BD2830 3278 package body SYS.KUPW$WORKER+
+22BD2830 6882 package body SYS.KUPW$WORKER+
+22BD2830 1259 package body SYS.KUPW$WORKER+
+229C03C4 2 anonymous block+

Job "SYSTEM"."SYS_IMPORT_SCHEMA_02" stopped due to fatal error at 15:00:52

how can i fix this?
is it possible that the export was done on a different version and that causes the problems ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 8 2010

Added on Feb 8 2010

#database-key-features, #error, #export-import-sql-loader-external-tables, #import

4 comments

4,023 views