Cannot Commit Partially Complete Transactions.


Transactions that drop tables or indexes do not perform the drop until a COMMIT statement is processed (with a few exceptions). In these cases, a beginning commit log record is written, followed by the usual commit log record. If the database server fails in between the two, the fast recovery process attempts to complete the commit the next time that you initialize the database server.

If this completion of the commit fails, the database server generates the preceding message.


To determine if you need to take action, examine the logical log as described in Interpreting Logical-Log Records.

Copyright© 2018 HCL Technologies Limited