ITRemote

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;