This is a table tracking the DBFS portion of the GoldenGate components
CREATE TABLE "GG_DBFS" ( "GD_ID" NUMBER, -- ID unique number "GD_DSC" VARCHAR2(4000), -- description of the DBFS filesystem "GD_MNT_PNT" VARCHAR2(4000), -- the mountpoint "GD_DBFS_FLSYS" VARCHAR2(4000), -- the filesystem "GD_RSRC_DEF" VARCHAR2(4000), -- CRS resource definition -- mount command used to mount filesystem CONSTRAINT "GG_DBFS_PK" PRIMARY KEY ("GD_ID") USING INDEX ENABLE ) ; CREATE OR REPLACE TRIGGER "BI_GG_DBFS" before insert on "GG_DBFS" for each row begin if :NEW."GD_ID" is null then select "GG_DBFS_SEQ".nextval into :NEW."GD_ID" from dual; end if; end; / ALTER TRIGGER "BI_GG_DBFS" ENABLE;