Backup - version difference
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Backup - version difference

  1. #1
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343
    Hi all, I know an Oracle export/import dump will not work when going from a higher version to a lower one - but will a Cold/hot backup work?

    Thanks,
    Shiva.

  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Cold backup doesn't work too.
    Because 2 different versions usually have 2 different dictionaries.

  3. #3
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343
    Thanks for confirming !!

    Shiva.

  4. #4
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    Actually Export/Import will work from higher version to lower version as long as the following two conditions are met --

    1. You are not using any new features in the higher versions that were not supported in the lower version.

    2. When exporting from higher version, use the EXP program that came with that version and when Importing in the lower use the IMP (or IMP73) program that came with the lower version

    I have done it several times exporting from 8.1.5 and then Importing into 8.0 and 7.3.4

    - Rajeev
    Rajeev Suri

  5. #5
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,001
    I don't think that it works when you go from 9i to 8i or 8 or 7.
    Oracle 8i does recognize the dump file from a 9i database.

  6. #6
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    well, I don't have a 9i database to test this but it sure worked fine from 8i to 8.0 and 7.3.x

    - Rajeev
    Rajeev Suri

  7. #7
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343
    Thanks for the suggestion Rajeev but I have never been actually able to do it because I do not have access to the box running the higher version, hence not possible to interchange executables !!

    Shiva.

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