Oracle - Unable to perform clean-up

Error: 

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?

 

Cause:

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

 

Solution:

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

- https://community.oracle.com/thread/664211?start=0&tstart=0

- http://docs.oracle.com/cd/E24693_01/server.11203/e17120/undo004.htm

Have more questions? Submit a request

0 Comments

Article is closed for comments.