Re: Oracle transactions and DDL statements.

From: Anurag Varma <avoracle_at_gmail.com>
Date: 9 May 2006 17:50:50 -0700
Message-ID: <1147222250.227239.164310@i40g2000cwc.googlegroups.com>

This might not help you ... but 10gR2 has a concept of flashback database
and creating restore points. Before you start your "transaction", you can create
a restore point which if time comes you can restore the whole database back
to using this feature.
10gR1 also has the concept of flashback database.

That is the closest you can get to regarding undoing the upgrade. Works on a database level though ..

see (oracle docs at tahiti.oracle.com ...): http://download-east.oracle.com/docs/cd/B19306_01/backup.102/b14192/intro007.htm#sthref74

Anurag Received on Tue May 09 2006 - 19:50:50 CDT