Inport from higher version for export file
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Inport from higher version for export file

  1. #1
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249

    Inport from higher version for export file

    I have two version of oracle 8.0.5 and 8.1.7

    How to import file in 8.0.5 from export file created in 8.1.7

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Always create exp dump using the lowest version.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    It is possible to take exp file from lower version

    But i have a export file of higher version and import it in lower version.

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    And is it working ?
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  5. #5
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    it will not work that i know.

    But i have two diffrent sites.

    At one site i have oracle 8.0.5 and at another 8.1.7

    now i want to transfer some tables from 8.1.7 to 8.0.5

    for that i need to take export from 8.1.7 and import it in 8.0.5

    is there any way ?

  6. #6
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Install 8.0.5 client (includes the exp.exe and imp.exe as well) at the 8.1.7 site and use that 8.0.5 exp client to get the exp dump.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  7. #7
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    Is there any other way ???

  8. #8
    Join Date
    May 2001
    Posts
    736
    Even after clearly explaining still how many methods do u want.

  9. #9
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    Thanks

  10. #10
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by adewri
    Install 8.0.5 client (includes the exp.exe and imp.exe as well) at the 8.1.7 site and use that 8.0.5 exp client to get the exp dump.
    You might not need to install 8.0.5 on server if you have 8.0.5 client installed somewhere else.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

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