How do I correct ORA-30036 when cleaning up Oracle Streams objects
Commands executed:
exec DBMS_AQADM.DROP_AQ_AGENT('CPT_TO_’);
delete from system.logmnr_spill$ where session# = session_id;
delete from system.logmnr_age_spill$ where session# = session_id;
delete from system.logmnr_log$ where session# = session_id;
delete from system.logmnr_session$ where session# = session_id;
delete from system.logmnr_restart_ckpt$ where session# = session_id;
delete from system.logmnr_restart_ckpt_txinfo$ where session# = session_id;
Error output
ERROR at line 1: ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'
delete from system.logmnr_session$ where session# = 160; ERROR at line 1: ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'