Backup - version difference

[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.

[Shestakov]

Cold backup doesn't work too.
Because 2 different versions usually have 2 different dictionaries.

[rshivagami]

Thanks for confirming !!

Shiva.

[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

[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.

[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

[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.