Oracle Distributed Systems

Name

DBMS_REPCAT.ALTER_MASTER_REPOBJECT

Synopsis

Just as you can propagate DDL to create objects with the EXECUTE_DDL procedure, you can also propagate DDL to alter objects with ALTER_MASTER_REPOBJECT. Unlike EXECUTE_DDL, ALTER_MASTER_REPOBJECT does not allow you to specify a list of master sites; the call affects all masters. In other words, Oracle does not support site-specific customizations of replicated objects.

You can perform DDL on any of these objects:

Function	Synonym
Index	Table
Package	Trigger
Package body	View
Procedure

Here is the specification:

PROCEDURE 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

Parameter Name	Description
sname	Name of the schema to which object oname belongs.
oname	Name of the object to alter.
type	The oname object type. Supported types: FUNCTION, INDEX, PACKAGE, PACKAGE BODY, SYNONYM, TABLE, TRIGGER, and VIEW.
ddl_text	Text of DDL statement to apply.
comment	Comment visible in DBA_REPOBJECT data dictionary view.
retry	If set to TRUE, procedure alters only objects whose status is not VALID at master sites.

Exceptions

Exception Name	Number	Description
commfailure	–23317	Unable to communicate with one or more master sites.
ddlfailure	–23318	DDL at master definition site failed.
missingobject	–23308	Object oname does not exist.
nonmasterdef	–23312	Calling site is not the master definition site.
notquiesced	–23310	Replication group gname is not quiesced.
typefailure ...