Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT.CREATE_SNAPSHOT_REPOBJECT

Purpose

To add a replicated object to your snapshot site. For additional information, refer to

Syntax

The parameters for the CREATE_SNAPSHOT_REPOBJECT procedure are shown in Table 12 - 107, and the exceptions are listed in Table 12 - 108. The syntax for this procedure is shown below:

DBMS_REPCAT.CREATE_SNAPSHOT_REPOBJECT(
                       sname           IN VARCHAR2,
                       oname           IN VARCHAR2, 
                       type            IN VARCHAR2, 
                       ddl_text        IN VARCHAR2 := NULL,
                       comment         IN VARCHAR2 := '',
                       gname           IN VARCHAR2 := ''
                       gen_obj_owner   IN VARCHAR2 := '')

Note: If the DDL is supplied without specifying a schema, 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.

Parameter Description
sname The name of the schema in which the object is located.
oname The name of the object that you want to add to the replicated snapshot object group. ONAME must exist at the associated master site.
type The type of the object that you are replicating. The types supported for snapshot sites are: PACKAGE, PACKAGE BODY, PROCEDURE, FUNCTION, SNAPSHOT, SYNONYM, and VIEW.
ddl_text For objects of type SNAPSHOT, the DDL text needed to create the object; for other types, use the default, NULL. If a snapshot with the same name already exists, 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 object group of the master site designated for this schema, Oracle raises a missingobject error.
comment This comment is added to the OBJECT_COMMENT field of the RepObject view.
gname The name of the replicated object group to which you are adding an object. The schema name is used as the default group name if none is specified.
gen_obj_owner The name of the user you want to assign as owner of the transaction.

Table 12 - 107. Parameters for CREATE_SNAPSHOT_REPOBJECT

Exception Description
nonsnapshot The invocation site is not a snapshot site.
nonmaster The master is no longer a master site.
missingobject The given object does not exist in the master's replicated object group.
duplicateobject The given object already exists with a different shape.
typefailure The type is not an allowable type.
ddlfailure The DDL did not succeed.
commfailure The master site is not accessible.
missingschema The schema does not exist as a database schema.

Table 12 - 108. Exceptions for CREATE_SNAPSHOT_REPOBJECT

Parameter	Description
`sname`	The name of the schema in which the object is located.
`oname`	The name of the object that you want to add to the replicated snapshot object group. ONAME must exist at the associated master site.
`type`	The type of the object that you are replicating. The types supported for snapshot sites are: PACKAGE, PACKAGE BODY, PROCEDURE, FUNCTION, SNAPSHOT, SYNONYM, and VIEW.
`ddl_text`	For objects of type SNAPSHOT, the DDL text needed to create the object; for other types, use the default, NULL. If a snapshot with the same name already exists, 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 object group of the master site designated for this schema, Oracle raises a missingobject error.
`comment`	This comment is added to the OBJECT_COMMENT field of the RepObject view.
`gname`	The name of the replicated object group to which you are adding an object. The schema name is used as the default group name if none is specified.
gen_obj_owner	The name of the user you want to assign as owner of the transaction.

Exception	Description
nonsnapshot	The invocation site is not a snapshot site.
nonmaster	The master is no longer a master site.
missingobject	The given object does not exist in the master's replicated object group.
duplicateobject	The given object already exists with a different shape.
typefailure	The type is not an allowable type.
ddlfailure	The DDL did not succeed.
commfailure	The master site is not accessible.
missingschema	The schema does not exist as a database schema.