Replication Management API Reference, 77 of 179

CREATE_SNAPSHOT_REPOBJECT procedure

This procedure adds a replicated object to your snapshot site.

Syntax

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 ,
   generate_80_compatible  IN   BOOLEAN   := TRUE
      gowner                          IN   VARCHAR2  := 'PUBLIC');

Parameters

Table 8-133 CREATE_SNAPSHOT_REPOBJECT Procedure Parameters

Parameter	Description
sname	Name of the schema in which the object is located.
oname	Name of the object that you want to add to the replicated snapshot object group. `ONAME` must exist at the associated master site.
type	Type of the object that you are replicating. The types supported for snapshot sites are: `PACKAGE`, `PACKAGE` `BODY`, `PROCEDURE`, `FUNCTION`, `SNAPSHOT`, `SYNONYM`, `TRIGGER`, and `VIEW`.
ddl_text	For objects of type `SNAPSHOT`, the DDL needed to create the object. For other types, use the default: '' (an empty string) If a snapshot with the same name already exists, then Oracle ignores the DDL and registers the existing snapshot as a replicated object. If the master table for a snapshot does not exist in the replicated master group of the master site designated for this schema, then Oracle raises a `missingobject` `error`. If the DDL is supplied without specifying a schema, then the default schema is the replication administrator's schema. Be sure to specify the schema if it is other than the replication administrator's schema.
comment	This comment is added to the `OBJECT_COMMENT` field of the `DBA_REPOBJECT` view.
gname	Name of the replicated master group to which you are adding an object. The schema name is used as the default group name if none is specified.
gen_objs_owner	Name of the user you want to assign as owner of the transaction.
min_communication	Set to `FALSE` if any master site is running Oracle7 release 7.3. Set to `TRUE` to minimize new and old values of propagation. The default is `TRUE`. For more information about conflict resolution methods, see Oracle8i Replication.
generate_80_ compatible	Set to `TRUE` if any master site is running a version of Oracle Server prior to Oracle8i release 8.1.5. Set to `FALSE` if replicated environment is a pure Oracle8i release 8.1.5 or greater environment.
gowner	Owner of the snapshot group.

Exceptions

Table 8-134 CREATE_SNAPSHOT_REPOBJECT Procedure Exceptions

Exception	Description
nonsnapshot	Invocation site is not a snapshot site.
nonmaster	Master is no longer a master site.
missingobject	Specified object does not exist in the master's replicated master group.
duplicateobject	Specified object already exists with a different shape.
typefailure	Type is not an allowable type.
ddlfailure	DDL did not succeed.
commfailure	Master site is not accessible.
missingschema	Schema does not exist as a database schema.
badsnapddl	DDL was executed but snapshot does not exist.
onlyonesnap	Only one snapshot for master table can be created.
badsnapname	Snapshot base table differs from master table.
missingrepgroup	Replicated master group does not exist.