Home » RDBMS Server » Server Utilities » Problem while Importing...
Problem while Importing... [message #359935] Tue, 18 November 2008 21:30 Go to next message
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.
Re: Problem while Importing... [message #359961 is a reply to message #359935] Wed, 19 November 2008 00:09 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Which are source and target database versions? Which versions of EXP and IMP utilities did you use during export and import process?
Re: Problem while Importing... [message #360092 is a reply to message #359935] Wed, 19 November 2008 10:12 Go to previous message
dbasupport
Messages: 11
Registered: November 2008
Location: dallas
Junior Member
both source and target are 10.2.0
Previous Topic: Import MS-Access tables in Oracle 9i
Next Topic: errors while impdp
Goto Forum:
  


Current Time: Wed Dec 07 04:54:20 CST 2016

Total time taken to generate the page: 0.07894 seconds