unable to add data file to golden gate table space

issue:
we could not add  data file to golden gate table space because of golden gate DDL and below is the fix.

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01653: unable to extend table GGADM.GGS_MARKER by 8192 in tablespace GG_TABLESPCE
ORA-06512: at line 1314
ORA-01653: unable to extend table GGADM.GGS_MARKER by 8192 in tablespace GG_TABLESPCE





ORA-01653: unable to extend table GGADM.GGS_MARKER by 8192 in tablespace GG_TABLESPCE

Owner=GGADM
Object_Name=GGS_MARKER
Tablespace= GG_TABLESPCE



1* select owner, TRIGGER_NAME, TRIGGER_TYPE, TABLE_OWNER, TRIGGERING_EVENT, TABLE_NAME from dba_triggers where owner='GGADM'
sdmdd> /

OWNER TRIGGER_NAME TRIGGER_TYPE TABLE_OWNER TRIGGERING_EVENT TABLE_NAME
------------------------------ ------------------------------ ---------------- ------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------
GGADM GGS_HEARTBEAT_TRIG BEFORE EACH ROW GGADM INSERT OR UPDATE GGS_HEARTBEAT
GGADM GGS_HEARTBEAT_TRIG_HIST BEFORE EACH ROW GGADM INSERT OR UPDATE GGS_HEARTBEAT_HISTORY


Solution:


This is a script which need to be run at the database end these scripts are present in the goldengate home

ddl_disable.sql

Add the datafile to the tablespace

ddl_enable.sql