Replication Management API Reference, 59 of 179

ALTER_MASTER_REPOBJECT procedure

This procedure alters an object in your replicated environment. You must call this procedure from the master definition site.

Syntax

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);

Parameters

Table 8-95 ALTER_MASTER_REPOBJECT Procedure Parameters

Parameter	Description
sname	Schema containing the object that you want to alter.
oname	Name of the object that you want to alter.
type	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. 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	If not `NULL`, then this comment is added to the `COMMENT` field of the `DBA_REPOBJECT` view.
retry	If retry is `TRUE`, then `ALTER_MASTER_REPOBJECT` alters the object only at masters whose object status is not `VALID`.

Exceptions

Table 8-96 ALTER_MASTER_REPOBJECT Procedure Exceptions

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