Partial rollback

[bprasath]

Hi,
Is there any way to do a partial rollback in a oracle database.

For ex:
Say i am posting entries into 3 tables for a single transaction. At the end i want to rollback the changes in two tables and commit the changes in one table. Is this possible in oracle


Babu

 

[subhavs]

Babu,

Have you tried to set multiple savepoints ? I think this might help to solve the problem ... Let me know if this works out.

- Subha Nothing is impossible, even the word impossible says I'm possible.

 

[MikeJones]

bprasath,

If you insert into table a, then b, then c you can rollback to any point in the transaction by using savepoints. However you must rollback cronologically so for instance in the above example you could not rollback just b as you would have to rollback c before you could rollback b.

The commands you need are savepoint and then rollback to <savepoint>

HTH,

Mike.