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

Hybrid 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

  2. #2
    Join Date
    Jan 2001
    Posts
    191
    IMP-00017: following statement failed with ORACLE error 959:
    "CREATE USER "NCL" IDENTIFIED BY VALUES '3092CC82C735C5A2' DEFAULT TABLESPAC"
    "E "WIZDATA" TEMPORARY TABLESPACE "TEMP_WIZERP_DATA""
    IMP-00003: ORACLE error 959 encountered
    ORA-00959: tablespace 'TEMP_WIZERP_DATA' does not exist

  3. #3
    Join Date
    Sep 2006
    Posts
    114
    Quote Originally Posted by xyz2000
    IMP-00017: following statement failed with ORACLE error 959:
    "CREATE USER "NCL" IDENTIFIED BY VALUES '3092CC82C735C5A2' DEFAULT TABLESPAC"
    "E "WIZDATA" TEMPORARY TABLESPACE "TEMP_WIZERP_DATA""
    IMP-00003: ORACLE error 959 encountered
    ORA-00959: tablespace 'TEMP_WIZERP_DATA' does not exist

    Ok i got it and now i'll try it again
    but thanx a lot for ur prompt response

  4. #4
    Join Date
    Sep 2005
    Posts
    278
    Also take care about privileges assigned to those two users. All the object and System privileges.

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