Import oracle 9i dmp in oracle 8i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Import oracle 9i dmp in oracle 8i

  1. #1
    Join Date
    Jun 2000
    Posts
    104

    Import oracle 9i dmp in oracle 8i

    Hello everybody,
    Is there any way to import in oracle 8i the dump from oracle 9i.Has anybody done that?
    bye
    Last edited by drishti; 05-04-2003 at 07:45 AM.

  2. #2
    Join Date
    Dec 2001
    Location
    Tel-Aviv,Israel
    Posts
    233
    Hi Drishti,

    Try to issue the export of the 9i schema using the 8i exp utility.
    If the 8i db and the 9i db are placed in differnt machines, update the tnsnames.ora so it can look at the 9i db, then from the 8i's machine execute: exp /@<9idb SID> ....
    In this way,all the env parameters are belong to the 8i db during the export.
    Now the dmp file suppose to be opened by the 8i import utility.

    I hope it will help you.

    Regards,
    Nir

  3. #3
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hi,
    if you habe metalink access search for imp/exp matrix
    Orca

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