Urgent!!! Migration
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Urgent!!! Migration

  1. #1
    Join Date
    Aug 2000
    Posts
    87
    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

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Did you run catalog.sql, catproc.sql and catexp.sql in the 8.1.6 db before importing??

  3. #3
    Join Date
    Aug 2000
    Posts
    87

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

    Regards,
    Vinod

  4. #4
    Join Date
    Mar 2001
    Posts
    635
    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
    Santosh

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width