Revert schema back to previous point in time - how?
raindogOct 16 2012 — edited Oct 16 2012In an 11gR2 database, I have a schema which contains data for an application. The developers are updating the application which will run a bunch of SQL to upgrade the data, DDL, PL/SQL, etc. in the schema. It should work, but if it fails they will want to revert to the pre-upgrade state.
It's not a ton of data, so I'll probably do an export before the upgrade and if necessary, drop the schema and import the pre-upgrade copy.
But I'm wondering if there is some other fancy way of doing this in the DB?
Flashback database is not an option - it's just one schema I'd want to revert.
Editions is not an option - table DDL, etc. will change and my research on editions shows that it doesn't support tables.
Just wondering what people usually do in this situation or what best practices are. Thanks!