Oracle Distributed Systems

Replicating DDL

The advanced replication facilities include support for replicating DDL commands to all master databases in a replication group. The DBMS_REPCAT procedures that provide this support are DBMS_REPCAT.ALTER_MASTER_REPOBJECT and DBMS_REPCAT.EXECUTE_DDL; their specifications follow:

PROCEDURE alter_master_repobject(
    sname    IN VARCHAR2,
    oname    IN VARCHAR2,
    type     IN VARCHAR2,
    ddl_text IN VARCHAR2,
    comment  IN VARCHAR2 := '',
    retry    IN BOOLEAN  := FALSE);

PROCEDURE execute_DDL(
    gname       IN VARCHAR2,
    master_list IN VARCHAR2 := NULL,
    ddl_text    IN VARCHAR2);

PROCEDURE execute_DDL(
    gname        IN VARCHAR2,
    master_table IN dbms_utility.dblink_array,
    ddl_text     IN VARCHAR2);

Note

Notice that ALTER_MASTER_REPOBJECT does not allow you to specify master sites, whereas EXECUTE_DDL does. ALTER_MASTER_REPOBJECT operates only on existing replicated objects and therefore executes at all master sites, whereas EXECUTE_DDL allows you to perform DDL operations independent of replicated objects. For example, you can use EXECUTE_DDL to create users at a remote site.

Restrictions

Note the following restrictions on DDL replication:

• Both DBMS_REPCAT.ALTER_MASTER_REPOBJECT and DBMS_REPCAT.EXECUTE_DDL must be called from the master definition site.

• DBMS_REPCAT.ALTER_MASTER_REPOBJECT requires the replication group to be quiesced.

• You must call regenerate replication support for tables that you alter with a call to DBMS_REPCAT.ALTER_MASTER_REPOBJECT.

Examples

The following examples demonstrate how to use theDDL replication ...