Oracle - Unable to perform clean-up


During the execution of the cleanup job, we are seeing this error in the logs (LogsArchiveAndCleanUp.log)

> 2016-04-05 09:55:42,691 ERROR [main] Log clean up
> db.DatabaseUtil.executeDeleteQuery(Unknown Source) - Unable to perform
> clean-up for table "AU_TRANSACTIONLOG"
> java.sql.SQLException: ORA-30036: unable to extend segment by 8 in undo
> tablespace 'UNDOTBS1'

How much space should be reserved for the undo tablespace to avoid this error?



The "undo Tablespace"size is completely occupied or the size for "AU_TransactionLog" is very large



Set the size of "undo tablespace" to auto-extend in the Database. Here's more information



Have more questions? Submit a request


Article is closed for comments.