roll back after commit

[swakoo]

is it possible to rollback after a commit?
can a savepoint work if i save before the commit.
or any idea is it possible to commit after 10k of records?
i am just afraid that the db might hang due to commit of too many records..
thanks in advance

 

[orca777]

Hi please look at the base concepts of transaction handling :

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c17trans.htm#7751

Regards
Carl r.
PS .: You have to register (for free at OTN)
to view the page

 

[ScottMattes]

Later releases of Oracle, 9.2 on I *think*, have something for showing previous values on rows. Check on asktom.oracle.com.

 

[rbrooker]

you can rollback committed transactions ( even dropping tables ) using flashback on oracle 9i and greater.

 

[swakoo]

can anyone show me how to use it?

 

[ScottMattes]

go to asktom.oracle.com and search on flashback - he gives excellent examples