Re: Oracle transactions and DDL statements.

From: <peter.koch.larsen_at_gmail.com>
Date: 10 May 2006 15:47:09 -0700
Message-ID: <1147301229.606387.14130@j33g2000cwa.googlegroups.com>

Anurag Varma skrev:

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

Hi Anurag.

Thankyou for your help. This is a solution we might look into. Unfortunately it will be unusable in a production environment - as a restore of the database likely will lose some transactions. For testing this is better than nothing.

/Peter
> 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 Wed May 10 2006 - 17:47:09 CDT