Hello everyone,
I have undo tablespace about 8Gig on my 95Gig database. There are few ETL jobs that runs each night. Undo tablespace use to be 4Gig recently we increased it to 8Gig because it is throwing error ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDO_TS'. When I looked at undo tablespace after seeing error it is 99% full. ETL jobs loads data, can we put no log so that it doesn’t take any undo tablespace while running?
Any suggestions greatly appreciated.
select * from v$version;
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
"CORE 10.2.0.5.0 Production"
TNS for HPUX: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production