9i rollback several specific table
Greetings All,I want to do some online test in Product environment, we will let many end-user to import data into several specific tables in database. If this test failed, we should clean all the data import by end-user from the database, so that we want rollback these specific tables to before the test.
DB version: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
I have one plans for this.
1 alter these specific table to read-only
2 use Original Export Release 9.2 to export these specific tables
3 alter these specific table to read-write
4 let end-user import the date
5 if the test failed, drop these specific tables
DB version: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
I have one plans for this.
1 alter these specific table to read-only
2 use Original Export Release 9.2 to export these specific tables
3 alter these specific table to read-write
4 let end-user import the date
5 if the test failed, drop these specific tables
0