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
Article is closed for comments.