DBMS_REPCAT.DROP_MASTER_REPOBJECT( sname IN VARCHAR2, oname IN VARCHAR2, type IN VARCHAR2, drop_objects IN BOOLEAN := FALSE)
Parameter | Description |
sname | The name of the schema in which the object is located. |
oname | The name of the object that you want to remove from the replicated object group. |
type | The type of object that you want to drop. |
drop_objects | By default, the object remains in the schema, but is dropped from the replicated object group; that is, any changes to the object are no longer replicated to other master and snapshot sites. To completely remove the object from all master sites in the replicated environment, set this argument to TRUE. |
Exception | Description |
nonmasterdef | The invocation site is not the master definition site. |
missingobject | The given object does not exist. |
typefailure | The given type parameter is not supported. |
commfailure | At least one master site is not accessible. |