Replication Management API Reference, 75 of 179

CREATE_MASTER_REPOBJECT procedure

This procedure makes an object a replicated object.

Replication of clustered tables is supported, but the use_existing_object parameter cannot be set to FALSE for clustered tables. In other words, the clustered table must be pre-created at all master sites participating in the master group. However, the pre-created tables do not need to contain the table data. So, the copy_rows parameter can be set to TRUE for clustered tables.

Syntax

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    := '');

Parameters

The following table describes the parameters for this procedure.

Table 8-128 CREATE_MASTER_REPOBJECT Procedure Parameters

Parameters	Description
sname	Name of the schema in which the object that you want to replicate is located.
oname	Name of the object you are replicating. If `DDL_TEXT` is `NULL`, then this object must already exist in the specified schema. To ensure uniqueness, table names should be a maximum of 27 bytes long, and package names should be no more than 24 bytes.
type	Type of the object that you are replicating. The types supported are: `TABLE`, `INDEX`, `SYNONYM`, `TRIGGER`, `VIEW`, `PROCEDURE`, `FUNCTION`, `PACKAGE`, and `PACKAGE` `BODY`.
use_existing_object	Indicate `TRUE` if you want to reuse any objects of the same type and shape at the current master sites. See Table 8-130 for more information. Note: This parameter must be set to `TRUE` for clustered tables.
ddl_text	If the object does not already exist at the master definition site, then you must supply the DDL text necessary to create this object. PL/SQL packages, package bodies, procedures, and functions must have a trailing semicolon. SQL statements do not end with trailing semicolon. Oracle does not parse this DDL before applying it; therefore, you must ensure that your DDL text provides the appropriate schema and object name for the object being created. If the DDL is supplied without specifying a schema (`sname` parameter), then the default schema is the replication administrator's schema. Be sure to specify the schema if it is other than the replication administrator's schema.
comment	This comment is added to the `OBJECT_COMMENT` field of the `DBA_REPOBJECT` view.
retry	Indicate `TRUE` if you want Oracle to reattempt to create an object that it was previously unable to create. Use this if the error was transient or has since been rectified. For example, if you previously had insufficient resources. If this is `TRUE`, then Oracle creates the object only at master sites whose object status is not `VALID`.
copy_rows	Indicate `TRUE` if you want the initial contents of a newly replicated object to match the contents of the object at the master definition site. See Table 8-130 for more information.
gname	Name of the object group in which you want to create the replicated object. The schema name is used as the default object group name if none is specified.

Table 8-129 CREATE_MASTER_REPOBJECT Procedure Exceptions

Exceptions	Description
nonmasterdef	Invocation site is not the master definition site.
notquiesced	Replicated master group has not been suspended.
duplicateobject	Specified object already exists in the replicated master group and retry is `FALSE`, or if a name conflict occurs.
missingobject	Object identified by `SNAME` and `ONAME` does not exist and appropriate DDL has not been provided.
typefailure	Objects of the specified type cannot be replicated.
ddlfailure	DDL at the master definition site did not succeed.
commfailure	At least one master site is not accessible.
notcompat	Not all remote masters in at least 7.3 compatibility mode.

Object Creations

Table 8-130 Object Creation at Master Sites

Object Already Exists?	COPY_ROWS	USE_EXISTING_ OBJECTS	Result
yes	TRUE	TRUE	`duplicatedobject` message if objects do not match. For tables, use data from master definition site.
yes	FALSE	TRUE	`duplicatedobject` message if objects do not match. For tables, DBA must ensure contents are identical.
yes	TRUE/FALSE	FALSE	`duplicatedobject` message.
no	TRUE	TRUE/FALSE	Object is created. Tables populated using data from master definition site.
no	FALSE	TRUE/FALSE	Object is created. DBA must populate tables and ensure consistency of tables at all sites.