问题描述：删除ogg用户表空间时告警ORA-00604、ORA-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/12247627