Name
DBMS_REPCAT.CREATE_SNAPSHOT_REPOBJECT
Synopsis
The CREATE_SNAPSHOT_REPOBJECT procedure adds an object to a specified snapshot replication group at a snapshot site. For new snapshot objects, this procedure generates row-level replication triggers for snapshots if the master table uses row-level replication. The specifications differ for Oracle7 and Oracle8 as follows. (Note the addition of the min_communication parameter in Oracle8.)
Oracle7 specification:
PROCEDURE DBMS_REPCAT. CREATE_SNAPSHOT_REPOBJECT (sname IN VARCHAR2, oname IN VARCHAR2, type IN VARCHAR2, ddl_text IN VARCHAR2 := '', comment IN VARCHAR2 := '', gname IN VARCHAR2 := '', gen_objs_owner IN VARCHAR2 := '');
Oracle8 specification:
PROCEDURE DBMS_REPCAT.CREATE_SNAPSHOT_REPOBJECT (sname IN VARCHAR2, oname IN VARCHAR2, type IN VARCHAR2, ddl_text IN VARCHAR2 := '', comment IN VARCHAR2 := '', gname IN VARCHAR2 := '', gen_objs_owner IN VARCHAR2 := '', min_communication IN BOOLEAN := TRUE);
Parameters
Parameter Name | Description |
---|---|
sname | Name of schema to which oname belongs. |
oname | Name of object to be added. |
type | Object type. Supported types are PACKAGE, PACKAGE BODY, PROCEDURE, SNAPSHOT, SYNONYM, and VIEW. |
ddl_text | DDL used to create object (for type SNAPSHOT only). |
comment | Comment on object, visible in DBA_REPOBJECT data dictionary view. |
gname | Name of snapshot group to which object is being added. Defaults to sname if not specified. |
gen_objs_owner | Name of the schema in which to create the generated trigger and trigger package or procedure ... |
Get Oracle Distributed Systems now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.