ORA-20782: Cannot DROP object used in Oracle GoldenGate replication while trigger is enabled-蒲公英云

ORA-20782: Cannot DROP object used in Oracle GoldenGate replication while trigger is enabled

向右看齐 2022-09-29 14:48 207阅读 0赞

今天在删除ogg用户的时候报了如下的问题：

SQL> drop user ogg cascade;
drop user ogg cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 2
ORA-20782: Oracle GoldenGate DDL Replication Error: Code Cannot
DROP object used in Oracle GoldenGate replication while trigger is enabled.
Consult Oracle GoldenGate documentation and/or call Oracle GoldenGate Technical
Support if you wish to do so., error stack: ORA-06512: at line 310
ORA-06512: at line 1272

解决办法：

SQL> drop trigger ggs_ddl_trigger_before

再次执行：

SQL> drop user ogg cascade
2 ;
drop user ogg cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-14452: attempt to create, alter or drop an index on temporary table already
in use

解决方法：

查出GOldengate用户的表

select table_name from tabs where table_name like ‘GG%’

select sid,serial# from v$session where sid =

(select sid from v$lock where id1 =

(select object_id from user_objects where object_name = upper(‘GGS_STICK’)))

结束session:

alter system kill session ‘sid,serial#‘;

SQL> drop user ogg cascade;

User dropped.

SQL>