URGENT: Problems for Import on NT
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: URGENT: Problems for Import on NT

  1. #1
    Join Date
    Feb 2001
    Posts
    1

    Question

    I'm carrying out a project on Database Migration from UNIX to Windows NT 4.0 (7.3.4 to 8.0.6).
    Below are the steps taken:

    Export database from UNIX server in 7.3.4 to Windows NT in 8.0.6
    FTP to NT in binary mode
    Pre-created a new database in 8.0.6 on Windows NT (using Database Assistant, a typical database with all the default tablespaces, datafiles, and rollback segments.)
    All the tablespaces, datafiles, and rollback segments are created to the same name as the original database; all the sizes are increased 50% (except for system tablespace to be remained in its default name with default datafiles and rollback segments)

    After importing the database using the Data Manager, following errors encountered from the import log file:
    1. IMP-00017: Following statement failed with Oracle error 904
    2. IMP-00003: Oracle error 904 encountered.
    3. IMP-00904: Invalid column name.
    4. IMP-00041: Warning: objected created with compilation warnings

    A snapshot of errors shown from the import log file (invalid column name):
    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 10240 NEXT 10240 MINEXTENTS 1 MAXEXTENTS 12"
    "1 PCTINCREASE 50 FREELISTS 1) TABLESPACE "TOOLS""
    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","DUMMY_BUFFER_NUMBER","
    ""DBLINK") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 1"
    "0240 NEXT 10240 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 50 FREELISTS 1 ) TA"
    "BLESPACE "TOOLS""
    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
    ......etc...

    Besides,
    1. How to test that the whole database is successfully imported?
    2. Can 7.3.4 be migrated to 8.0.6 simultaneously while migrating across platforms?
    3. Will the filesize change after imported to the new DB?

    Thanks a lot for any help and advice.




  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Count Schema objects and their status before export and after import. It should be same except for SYS and SYSTEM which change with new version.

    export/import is best option if you are upgrading across platforms.

    What dump file you are talking about ? It will change if the objects count does change.

    [url]http://www.dbasupport.com/forums/showthread.php?threadid=5289[/url]
    Reddy,Sam

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    The files sizes would not change, but you may loose some of the table extent specification, if you had done the export with the COMPRESS=Y. What this would do is that of setting the initial extent size to the total extent size of the table and then the others would set to default. Be carefull in this case, because, you might see a huge tablespace gulp.

    As sreddy, suggested you can make sure the schema counts are correct, also check to make sure the import log, whether it had created any errors. Then try to connect in as a user to one of the user schemas and confirm that you are able to establish the connection. then you can check the dba_tables and make sure that the user tables are all there.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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