Urgent!!! Migration

[vinodkmg]

Hi All,

I am in the process of Migrating a database from 7.3.4 to 8.1.6.0.0. On Aix 4.3.2

I have 7.3.4 database full Export dump.

I have created a new instance of 8.1.6.0.0 version.

I am not using migration utility i am using Export/Import to migrate.

When do a full database import i am getting some errors like:

IMP-00017: following statement failed with ORACLE error 904:
"CREATE INDEX "DEF$_CALLDEST_N1" ON "DEF$_CALLDEST" ("DEFERRED_TRAN_DB" , "D"
"EFERRED_TRAN_ID" , "CALLNO" , "DUMMY_BUFFER_NUMBER" ) PCTFREE 10 INITRANS "
"2 MAXTRANS 255 STORAGE (INITIAL 16384 NEXT 16384 MINEXTENTS 1 MAXEXTENTS 50"
"5 PCTINCREASE 50 FREELISTS 1) TABLESPACE "SYSTEM""
IMP-00003: ORACLE error 904 encountered
ORA-00904: invalid column name
IMP-00017: following statement failed with ORACLE error 904:
"ALTER TABLE "DEF$_CALLDEST" ADD CONSTRAINT "DEF$_CALLDEST_PRIMARY" PRIMARY"
" KEY ("DEFERRED_TRAN_DB","DEFERRED_TRAN_ID","CALLNO","DBLINK") USING INDEX "
"PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 16384 NEXT 16384 MINEXT"
"ENTS 1 MAXEXTENTS 505 PCTINCREASE 50 FREELISTS 1 ) TABLESPACE "SYSTEM""
IMP-00003: ORACLE error 904 encountered
ORA-00904: invalid column name
IMP-00017: following statement failed with ORACLE error 904:
"COMMENT ON COLUMN "DEF$_CALLDEST"."DEFERRED_TRAN_DB" IS 'Originating datab"
"ase for the deferred transaction'"
IMP-00003: ORACLE error 904 encountered
ORA-00904: invalid column name
IMP-00017: following statement failed with ORACLE error 904:
"COMMENT ON COLUMN "DEF$_CALLDEST"."DEFERRED_TRAN_ID" IS 'Transaction ID'"
IMP-00003: ORACLE error 904 encountered
ORA-00904: invalid column name
IMP-00017: following statement failed with ORACLE error 904:
"COMMENT ON COLUMN "DEF$_CALLDEST"."CALLNO" IS 'Unique ID of call within tr"
"ansaction'"
IMP-00003: ORACLE error 904 encountered
ORA-00904: invalid column name
IMP-00017: following statement failed with ORACLE error 904:
"COMMENT ON COLUMN "DEF$_CALLDEST"."DUMMY_BUFFER_NUMBER" IS 'Used for forei"
"gn key reference only'"
IMP-00003: ORACLE error 904 encountered
ORA-00904: invalid column name
. . importing table "DEF$_DEFAULTDEST" 0 rows imported
. . importing table "DEF$_DESTINATION" 0 rows imported
IMP-00017: following statement failed with ORACLE error 904:
"COMMENT ON COLUMN "DEF$_DESTINATION"."LAST_TRAN_ID" IS 'Transaction ID of "
"last transaction propagated'"
IMP-00003: ORACLE error 904 encountered
ORA-00904: invalid column name
IMP-00017: following statement failed with ORACLE error 904:
"COMMENT ON COLUMN "DEF$_DESTINATION"."LAST_TRAN_DB" IS 'Source of last tra"
"nsaction propagated'"
IMP-00003: ORACLE error 904 encountered
ORA-00904: invalid column name
IMP-00017: following statement failed with ORACLE error 904:
"COMMENT ON COLUMN "DEF$_DESTINATION"."LAST_ERROR" IS 'Oracle error number "
"from last push'"
IMP-00003: ORACLE error 904 encountered
ORA-00904: invalid column name
IMP-00017: following statement failed with ORACLE error 904:
"COMMENT ON COLUMN "DEF$_DESTINATION"."LAST_MSG" IS 'Error message from las"
"t push'"
IMP-00003: ORACLE error 904 encountered
ORA-00904: invalid column name
. . importing table "DEF$_ERROR" 0 rows imported
IMP-00017: following statement failed with ORACLE error 904:
"ALTER TABLE "DEF$_ERROR" ADD CONSTRAINT "DEF$_ERROR_PRIMARY" PRIMARY KEY ("
""DEFERRED_TRAN_DB","DEFERRED_TRAN_ID","DESTINATION") USING INDEX PCTFREE 10"
" INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 16384 NEXT 16384 MINEXTENTS 1 MAX"
"EXTENTS 505 PCTINCREASE 50 FREELISTS 1 ) TABLESPACE "SYSTEM""
IMP-00003: ORACLE error 904 encountered
ORA-00904: invalid column name
IMP-00017: following statement failed with ORACLE error 904:
"COMMENT ON COLUMN "DEF$_ERROR"."DEFERRED_TRAN_DB" IS 'The database origina"
"ting or copying the deferred transaction'"
IMP-00003: ORACLE error 904 encountered
ORA-00904: invalid column name
IMP-00017: following statement failed with ORACLE error 904:
"COMMENT ON COLUMN "DEF$_ERROR"."DEFERRED_TRAN_ID" IS 'The ID of the transa"
"ction that originated or copied the deferred transaction'"
IMP-00003: ORACLE error 904 encountered
ORA-00904: invalid column name
IMP-00017: following statement failed with ORACLE error 904:
"COMMENT ON COLUMN "DEF$_ERROR"."CALLNO" IS 'Unique ID of call that caused "
"an error'"
IMP-00003: ORACLE error 904 encountered
ORA-00904: invalid column name
IMP-00017: following statement failed with ORACLE error 904:
"COMMENT ON COLUMN "DEF$_ERROR"."ERROR_TIME" IS 'Time error occurred'"
IMP-00003: ORACLE error 904 encountered
ORA-00904: invalid column name

I know that this is cause due to structural change in 8i.So kindly let me know what the alternative to fix this.Its Urgent.

Regards,
Vinod Kumar

[Halo]

Did you run catalog.sql, catproc.sql and catexp.sql in the 8.1.6 db before importing??

[vinodkmg]

Yes,I have run the necessary scripts on new 8.1.6.0.0 instance.

Regards,
Vinod

[santoshym]

Hi

Try using

Ignore=y

in your import statament.You have to use Ignore=y
I think because those particular objects are allready
existing in the system tablespace.

Regards