When you execute the DELETE FROM <Table> command in Oracle, you may receive below error:
Say: DELETE FROM password_history
—————————
ODBC 32Bit Test Program
—————————
SQLSTATE: NA000
Native Error Code:1562
Driver Message:[Microsoft][ODBC driver for Oracle][Oracle]ORA-01562: failed to extend rollback segment number 7
ORA-01628: max # extents (256) reached for rollback segment R06
—————————
OK
—————————
Workaround:
If Deleting the all the records from a table is failing do delete operation in phases with use of filters to limit the records to be deleted in single shot.
Say: DELETE FROM password_history where Attempt_ID > 1
