删除ogg用户表空间时告警ORA-00604、ORA-20782

问题描述:删除ogg用户表空间时告警ORA-00604ORA-20782,如下所示:
1、异常重现
SYS@orcl> drop tablespace ogg_tbs including contents and datafiles;
drop tablespace ogg_tbs including contents and datafiles
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 2
ORA-20782: Oracle GoldenGate DDL Replication Error: Code :ORA-20782: 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 305
ORA-06512: at line 1266
2、异常原因
安装OGG时配置开启过DDL捕获功能,OGG的DDL捕获依赖DDL触发器实现,DDL处于enabled状态,drop tablespace操作也属于DDL操作,所以产生ORA-00604 ORA-20782错误.
3、解决方案
--查触发器状态
SYS@orcl> col owner for a15
SYS@orcl> col trigger_name for a25
SYS@orcl> col triggering_event for a30
SYS@orcl> col status for a15
SYS@orcl> select owner,trigger_name,trigger_type,triggering_event,status from dba_triggers where trigger_name like 'GGS%'

OWNER TRIGGER_NAME TRIGGER_TYPE TRIGGERING_EVENT STATUS
--------------- ------------------------- ---------------- ------------------------------ ---------------
SYS GGS_DDL_TRIGGER_BEFORE BEFORE EVENT DDL ENABLED

SYS@orcl> drop trigger GGS_DDL_TRIGGER_BEFORE;

Trigger dropped.
--成功删除ogg表空间
SYS@orcl> drop tablespace ogg_tbs including contents and datafiles;

Tablespace dropped.

参考文档:https://blog.csdn.net/weixin_40913898/article/details/122476274