Export Import Urgent
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: Export Import Urgent

  1. #1
    Join Date
    Sep 2000
    Posts
    305
    I have an export file of Oracle 8.1.6
    Now I want to import it in Oracle 8.1.5
    how to import that file?

    Please tell me urgently

    Thanks is advance
    Shailendra

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    AFAIK, you can't ...
    you should export using 815 exp utility, nevertheless if you can't, you'll have to find a 816 instance :/

  3. #3
    Join Date
    Sep 2000
    Posts
    96
    I'm not sure that can be done. I don't think there is backward compatibility with the import/export option. Does anyone else know this for sure?

  4. #4
    NOPE, I have tried this in the past and PIPO is 100%
    The brain is a wonderful organ; it starts working the moment you get up in the morning and does not stop until you get into the office.

  5. #5
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    You always can do the import through the network using your 8.1.6 import utility:

    1. Configure the tnsnames in your server 8.1.6 to access to the 8.1.5 database server
    2. Do the import in the 8.1.6 server

    imp user/password@sid_8.1.5 .....

    Logically the performance of the import is worse than locally

    Regards

    Angel

  6. #6
    Join Date
    Sep 2000
    Posts
    305
    is it possible or not? I am using export and import utility only
    if yes then how do I import and one more thing is charcterset has any role in this export and import of different version.

    ......

  7. #7
    Join Date
    Sep 2000
    Posts
    305
    thanks aarroyob

    but my export file is from oracle 8.1.6 and now I want to import it into Oracle 8.1.5 are you saying the same thing
    well aarroyob can you please explain me in detail

    thanks


  8. #8
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    I have done as explained above.

  9. #9
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    I think is clear, but If you don't understand something say me and I will try to explain more cleanly.

  10. #10
    Join Date
    Sep 2000
    Posts
    305
    well aarroyob as you are saying that

    1. Configure the tnsnames in your server 8.1.6 to access to the 8.1.5 database server
    2. Do the import in the 8.1.6 server

    imp user/password@sid_8.1.5 .....

    I am not getting properly what you are saying that I have to import it in Oracle 8.1.6 server is it? as you have written in your second point.
    But I want to import it in 8.1.5 please explain me

    thanks

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