Backup - version difference

Printable View

03-20-2002, 04:53 PM
rshivagami

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.
03-20-2002, 05:07 PM
Shestakov

Cold backup doesn't work too.
Because 2 different versions usually have 2 different dictionaries.
03-20-2002, 05:15 PM
rshivagami

Thanks for confirming !!

Shiva.
03-20-2002, 05:18 PM
rsuri

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
03-20-2002, 06:03 PM
gandolf989

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.
03-20-2002, 06:06 PM
rsuri

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
03-20-2002, 06:10 PM
rshivagami

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.