Full DB Export from 8i and Import into 10g
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Full DB Export from 8i and Import into 10g

Threaded View

  1. #1
    Join Date
    Sep 2006
    Posts
    114

    Full DB Export from 8i and Import into 10g

    i am trying to export full db (8i) into 10g db

    at 8i machine which has two schemas (NCL,NCL_TEST)

    exp system/gateway@8i_db file=c:\fullbackup.dmp full=y

    Export terminated Successfully
    and then i copied the dumpfile to destination 10g DB machine

    At 10g Machine
    and when i try to import the database with the following

    imp system/gateway@10g_db file=c:\fullbackup.dmp full=y log=c:\log1.log

    Import is terminated with warning
    I also have attached log file which contains enterires like

    User "NCL" does not exist
    User "NCL_TEST" does not exist

    Can u please look at the log file i have attached

    May be i am wrong but i think we don't need to create users at the destination DB if we are using full import
    i also have the same tablespaces in both 8i and 10g DB
    I am doing an export at 8i machine and trying to import at 10g machine locally

    Can anybody please help me in this regard?

    thanx in advance
    Attached Files Attached Files

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