I want to migrate from Oracle 8i (8.1.7) to 10gR1 on a new server. I will shut down 8i and run with 10gR1 on a new server. If any of my applications are not working with 10g, I need to fall back to 8i on the old server. Is it possible to take only the delta changes from 10gR1 which has happend for such a duration and apply them to 8i (8.1.7)? If yes, how? If no, what is the best practice?
It is not possible to replay transactions from a 10g database in an 8i database. In all of my upgrades, I have never had to resort to going back to an older Oracle version. That is because we test the upgrade process and we test our applications against the newest version in a test environment before upgrading production. If you have performed adequate testing, going back to an older Oracle version should not arise.
Dig Deeper on Oracle database backup and recovery
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.