Rem
Rem $Header: cathssn.sql 22-nov-96.10:15:40 hasun Exp $
Rem
Rem cathssn.sql
Rem
Rem  Copyright (c) Oracle Corporation 1996. All Rights Reserved.
Rem
Rem    NAME
Rem      cathssn.sql - Heterogeneous Services SNapshots
Rem
Rem    DESCRIPTION
Rem      Runs all scripts for heterogeneous services snapshots
Rem
Rem    NOTES
Rem      Must be run when connected to SYS or INTERNAL
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    hasun       11/22/96 - Created
Rem

--- This table records the snapshots that are created at foreign datastores
--- by RepAPI
CREATE TABLE system.repcat$_fds_repobjects
(
  gname           VARCHAR2(30),   --- replicated object group name
  sname           VARCHAR2(30),   --- owner of replicated object
  oname           VARCHAR2(30),   --- replicated object name,
  type            INTEGER         --- object type
                    CONSTRAINT repcat$_fds_repobjects_type
                      CHECK (type IN (-1)),
  dblink          VARCHAR2(128),  --- fds site 
  object_comment  VARCHAR2(4000), --- comment for object
  status          INTEGER         --- status of object
                    CONSTRAINT repcat$_fds_repobjects_status
                      CHECK (status IN (0, 1, 2, 3, 4)),
  flag            RAW(4)          --- misc. information (currently not used)
                    DEFAULT '00000000'
)
/
--- Can't use a primary key constraint because sname may be NULL
--- for certain FDS sites (i.e., schemas/users not supported)
CREATE UNIQUE INDEX repcat$_fds_repobjects_uidx
  ON system.repcat$_fds_repobjects(oname, type, sname, gname, dblink);
/
comment on table SYSTEM.REPCAT$_FDS_REPOBJECTS is
'Information about heterogeneous replicated objects'
/
comment on column SYSTEM.REPCAT$_FDS_REPOBJECTS.GNAME is
'Name of the object''s object group'
/
comment on column SYSTEM.REPCAT$_FDS_REPOBJECTS.SNAME is
'Name of the object owner'
/
comment on column SYSTEM.REPCAT$_FDS_REPOBJECTS.ONAME is
'Name of the object'
/
comment on column SYSTEM.REPCAT$_FDS_REPOBJECTS.TYPE is
'Type of the object'
/
comment on column SYSTEM.REPCAT$_FDS_REPOBJECTS.DBLINK is
'The database link to the snapshot site'
/
comment on column SYSTEM.REPCAT$_FDS_REPOBJECTS.STATUS is
'Status of the last create or alter request on the object'
/
comment on column SYSTEM.REPCAT$_FDS_REPOBJECTS.OBJECT_COMMENT is
'Description of the replicated object'
/
comment on column SYSTEM.REPCAT$_FDS_REPOBJECTS.FLAG is
'Information about replicated object'
/
@@dbmsrs3g.sql
@@prvtrs3g.plb
@@dbmshssn.sql
@@prvthssn.plb
