oracle export 10G to 9i
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 17

Thread: oracle export 10G to 9i

Hybrid View

  1. #1
    Join Date
    Mar 2007
    Posts
    9

    oracle export 10G to 9i

    Hi GUys

    Please can some one help on how to do export for oracle database from version 10G to 9i;

    I have a 9i database and I want to import from 10G and use this dump in the version 9i.

    Please advise.

    Thanks and regards

  2. #2
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    TaKe export of 10g database using 9i's EXP and import in 9i

  3. #3
    Join Date
    Mar 2007
    Posts
    9
    Thanks for the reply.

    But I try to use the exp.exe for version 9.i to do the export for 10G. and it does not work.

    So please more details will be welcome.

    Regards

  4. #4
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    What problem are you facing?

    What happen when you are trying to take export?

  5. #5
    Join Date
    Mar 2007
    Posts
    9
    I have error message about some DLL missing....for this version of export. so is like oracle expect all the necessary dll files to complete this export...

    same thing happen when I use the imp.exe file for version 10G to import into
    9i.... it request: oracommon10.dll

    thx.

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    have you installed the client correctly

  7. #7
    Join Date
    Mar 2007
    Posts
    9
    the problem is not even the client, because I have not install the dump yet, to use client version to access database; right now I'am just trying to import a dump that was created by oracle 10G into oracle 9i. and the import process cannot finish because the oracle version for import and export is not the same.

  8. #8
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    You cannot not import dmp file created by 10g exp.exe in 9i

    Take export of oracle 10g database using Oracle 9i exp.exe.

  9. #9
    Join Date
    Mar 2007
    Posts
    9
    that was done but as I said above, there is error msg about some of the DLL missing; when you try to use exp.exe for 9.i on 10G.

  10. #10
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    You have to check as davey23uk said.

    10g and 9i on same machine ?

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