Name
DBMS_REPCAT.CREATE_MASTER_REPOBJECT
Synopsis
The CREATE_MASTER_REPOBJECT procedure adds a new replicated object to an existing replication group.
PROCEDURE DBMS_REPCAT.CREATE_MASTER_REPOBJECT( sname IN VARCHAR2, oname IN VARCHAR2, type IN VARCHAR2, use_existing_object IN BOOLEAN := TRUE, ddl_text IN VARCHAR2 := NULL, comment IN VARCHAR2 := '', retry IN BOOLEAN := FALSE, copy_rows IN BOOLEAN := TRUE, gname IN VARCHAR2 := '');
It is generally easier to instantiate objects that you intend to replicate at all participating master sites before calling CREATE_MASTER_REPOBJECT. This avoids the additional time and complexity of having the procedure create and populate the replicated objects itself.
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. |
use_existing_object | Set to TRUE to reuse existing objects with the same name and structure at master sites. |
ddl_text | Text of DDL statement to create object oname (use this parameter if and only if object does not already exist). |
comment | Comment on replicated object, visible in DBA_REPOBJECT data dictionary view. |
retry | Flag indicating that this call is a reattempt of an earlier call. An attempt is made to create object only at master sites where it does not exist with a status of VALID. |
copy_rows | Populate tables and other master sites with data from master definition ... |
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.