| Problem while Importing... [message #359935] |
Tue, 18 November 2008 21:30  |
dbasupport
Messages: 11
Registered: November 2008
Location: dallas
|
Junior Member |
|
|
Hi All,
This is the exact command i used for export:
exp system/oracle@db01 file=/u01/app/oracle/dumpdir/exp.dmp full=y rows=n constraints=n triggers=n indexes=n grants=y log=/u01/app/oracle/dumpdir/exp.log
Export terminated successfully without warnings.
My export terminated successfully without warning. My propose is just to export the structures not the data.
But while importing i am getting lots of error messages and at last my import completed with:
Import terminated successfully with warnings.
Some of the messages i get are as follows:
IMP-00003: ORACLE error 30371 encountered
ORA-30371: column cannot define a level in more than one dimension
IMP-00017: following statement failed with ORACLE error 30371:
"CREATE DIMENSION "TIMES_DIM" LEVEL "DAY" IS ("TIMES"."TIME_ID") LEVEL "MONT"
"H" IS ("TIMES"."CALENDAR_MONTH_ID") LEVEL "QUARTER" IS ("TIMES"."CALENDAR_Q"
"UARTER_ID") LEVEL "YEAR" IS ("TIMES"."CALENDAR_YEAR_ID") LEVEL "FIS_WEEK.........................
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYS.I_JOB_JOB) violated
ORA-06512: at "SYS.DBMS_IJOB", line 210
ORA-06512: at line 1
. importing SH's objects into SH
IMP-00003: ORACLE error 23327 encountered
ORA-23327: imported deferred rpc data does not match GLOBAL NAME of importing db
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_DEFER_IMPORT_INTERNAL", line 30
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 23327:
"BEGIN SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('DB01.REGRESS.RDB"
"MS.DEV.US.ORACLE.COM','Linuxi386/Linux-2.0.34-8.1.0'); END;"
IMP-00003: ORACLE error 23327 encountered
ORA-23327: imported deferred rpc data does not match GLOBAL NAME of importing db
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_DEFER_IMPORT_INTERNAL", line 30
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 23327:
"BEGIN SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('DB01.REGRESS.RDB"
"MS.DEV.US.ORACLE.COM','Linuxi386/Linux-2.0.34-8.1.0'); END;"
IMP-00003: ORACLE error 23327 encountered
ORA-23327: imported deferred rpc data does not match GLOBAL NAME of importing db
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_DEFER_IMPORT_INTERNAL", line 30
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 23327:
"BEGIN SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('DB01.REGRESS.RDB"
"MS.DEV.US.ORACLE.COM','Linuxi386/Linux-2.0.34-8.1.0'); END;"
IMP-00003: ORACLE error 23327 encountered
ORA-23327: imported deferred rpc data does not match GLOBAL NAME of importing db
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_DEFER_IMPORT_INTERNAL", line 30
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 23327:
"BEGIN SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('DB01.REGRESS.RDB"
"MS.DEV.US.ORACLE.COM','Linuxi386/Linux-2.0.34-8.1.0'); END;"
please advice how can i solve this problems.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
