Data Warehouse Job failing with Oracle undo tablespace error
book
Article ID: 111837
calendar_today
Updated On:
Products
Clarity PPM SaaS
Clarity PPM On Premise
Issue/Introduction
Load Data Warehousejob fails with the following Oracle errors:
ORA-00604: error occurred at recursive SQL level 1.
ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'.
Cause
This is Oracle database resource issue so please our Saas team investigate it before re-submitting your job.
Resolution
Once they have been completed their investigation please re-submit the job.
Feedback
thumb_up
Yes
thumb_down
No