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 ... |
Get Oracle Distributed Systems now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.