Oracle Database Discussions

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.