Name
DBMS_REPCAT.DROP_MASTER_REPOBJECT
Synopsis
The DROP_MASTER_REPOBJECT procedure drops a replicated object in an existing replication group at the master site and optionally drops the object from all sites. Do not drop tables to which snapshots are mastered.
PROCEDURE DBMS_REPOBJECT.DROP_MASTER_REPOBJECT (sname IN VARCHAR2, oname IN VARCHAR2, type IN VARCHAR2, drop_objects IN BOOLEAN := FALSE);
Parameters
Parameter Name | Description |
|---|---|
sname | Name of the schema to which oname belongs. |
oname | Name of the object to be added. |
type | Object type. Valid types: TABLE, INDEX, SYNONYM, TRIGGER, VIEW, PROCEDURE, FUNCTION, PACKAGE, and PACKAGE BODY. |
drop_objects | If TRUE, drop the object at all master sites; default is FALSE. |
Exceptions
Exception Name | Number | Description |
|---|---|---|
commfailure | –23317 | Not all master sites are reachable. |
missingobject | –23308 | Object oname does not exist. |
nonmasterdef | –23373 | Calling site is not the master definition site for replication group gname. |
typefailure | –23319 | The type is not supported. |
Restrictions
This procedure must be called from the master definition site.
The replication group must already exist and be quiesced.