This is a table tracking the DBFS portion of the GoldenGate components

[code language=”sql”]

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;
[/code]