Distributed Schema Management

In a replication environment, all DDL statements must be issued using either Oracle Enterprise Manager or the DBMS_REPCAT package in the replication management API. Specifically, if you use the DBMS_REPCAT package, then use the CREATE_MASTER_REPOBJECT procedure to add objects to a master group, use ADD_MASTER_COLUMN to add columns to a master table, and use ALTER_MASTER_REPOBJECT to modify replicated objects. You can also use the EXECUTE_DDL procedure.

When you use either Oracle Enterprise Manager or the DBMS_REPCAT package, all DDL statements are replicated to all of the sites participating in the replication environment. In some cases, you can also use export/import to create replicated objects.