Can someone tell me if rollback is possible for an extremely large
transaction (deleting 2000000 records from a table using a single delete
statement.This is 50% of table contents)
I�m using 7.3.0.30 with DEMO Log.
If the log is auto overwritten during the execution of the delete and
the delete is then aborted. (i.e. client/server is killed) will the
statement be rolled back?
The db was restarted but did not come to an online state. I gave up on
it after 3 hours (kernel.exe was busy during this period).
Regards,
Ajit