Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT.ALTER_MASTER_REPOBJECT

Purpose

To alter an object in your replicated environment. You must call this procedure from the master definition site. For additional information, refer to

Syntax

The parameters for the ALTER_MASTER_REPOBJECT procedure are described in Table 12 - 74, and the exceptions are listed in Table 12 - 75. The syntax for this procedure is shown below:

DBMS_REPCAT.ALTER_MASTER_REPOBJECT(
			sname		IN	VARCHAR2, 
			oname		IN	VARCHAR2, 
			type		IN	VARCHAR2, 
			ddl_text	IN	VARCHAR2, 
			comment	IN	VARCHAR2 := '', 
			retry		IN	BOOLEAN := FALSE)

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 schema containing the object that you want to alter.
oname The name of the object that you want to alter.
type The type of the object that you are altering. The types supported are: TABLE, INDEX, SYNONYM, TRIGGER, VIEW, PROCEDURE, FUNCTION, PACKAGE, and PACKAGE BODY.
ddl_text The DDL text that you want used to alter the object. Oracle does not parse this DDL before applying it; therefore, you must ensure that your DDL text provides the appropriate schema and object name for the object being altered.
comment If not null, this comment will be added to the COMMENT field of the RepObject view.
retry If retry is TRUE, ALTER_MASTER_REPOBJECT alters the object only at masters whose object status is not VALID.

Table 12 - 74. Parameters for ALTER_MASTER_REPOBJECT

Exception Description
nonmasterdef The invocation site is not the master definition site.
notquiesced The associated object group has not been suspended.
missingobject The object identified by SNAME and ONAME does not exist.
typefailure The given type parameter is not supported.
ddlfailure DDL at the master definition site did not succeed.
commfailure At least one master site is not accessible.

Table 12 - 75. Exceptions for ALTER_MASTER_REPOBJECT

Parameter	Description
`sname`	The schema containing the object that you want to alter.
`oname`	The name of the object that you want to alter.
`type`	The type of the object that you are altering. The types supported are: TABLE, INDEX, SYNONYM, TRIGGER, VIEW, PROCEDURE, FUNCTION, PACKAGE, and PACKAGE BODY.
`ddl_text`	The DDL text that you want used to alter the object. Oracle does not parse this DDL before applying it; therefore, you must ensure that your DDL text provides the appropriate schema and object name for the object being altered.
`comment`	If not null, this comment will be added to the COMMENT field of the RepObject view.
`retry`	If retry is TRUE, ALTER_MASTER_REPOBJECT alters the object only at masters whose object status is not VALID.

Exception	Description
nonmasterdef	The invocation site is not the master definition site.
notquiesced	The associated object group has not been suspended.
missingobject	The object identified by SNAME and ONAME does not exist.
typefailure	The given type parameter is not supported.
ddlfailure	DDL at the master definition site did not succeed.
commfailure	At least one master site is not accessible.