Error when purging log unable to extend tablespace ‘UNDO’
Error when purging log unable to extend tablespace ‘UNDO’
Oracle Data Integrator 10.1.3 is a great tool and can even run fully functional against Oracle Express which is the only free Oracle database product available.
Problem
This limited database has it’s draw backs for production use. If Data Integrator is executing scenarios real time, or if the logs are never cleared it could quickly exceed the 5GB storage limit and this nasty error could show up.
Error When Purging Log
java.sql.SQLException: ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDO'
Use Oracle APEX to find the maxed undo tablespace:
The problem is Oracle Express can’t extend the tablespace. Ultimately once the undo tablespace is full all reports need to be removed manually before a purge logs can be executed.
Solution
Sometimes purging the logs from the command line will work but not from the Operator view:
startcmd.bat OdiPurgeLog "-PURGE_REPORTS=1"
Otherwise manually remove all reports and then purge using the command line or trash icon. Hint selecting multiple and right clicking ‘delete’ reduces the selection to one item. Instead select multiple and press delete key.
If this doesn’t work delete the contents of the reports tables. I’d start with the SNP_EXP_TXT table because this could have 50million+ records.
Author’s Note
Initial md Generated using https://github.com/jsr6720/wordpress-html-scraper-to-md
Original Wordpress categories: [‘Oracle Data Integrator’]
Original Wordpress tags: “Oracle Data Integrator”, “Data Integrator”, “log purge error”, “ODI”, “oracle express”, “ORA_30036”
Original Wordpress comments: None
Significant Revisions
tags: 2011, wordpress, txcowboycoder, odi, oracle-data-integrator, error, troubleshooting, oracle
- Nov 17th, 2024 Copied down original files and updated layout
- May 6th, 2024 Converted to jekyll markdown format and copied to personal site
- Apr 11th, 2011 Originally published on txcowboycoder wordpress site