GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

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'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center