Oracle in a Nutshell

Calls

PROCEDURE DBMS_REPCAT.ADD_GROUPED_COLUMNS (sname IN VARCHAR2, oname IN VARCHAR2, column_group IN VARCHAR2, list_of_column_names IN {VARCHAR2 | DBMS_REPCAT.VARCHAR2s});

Adds list_of_column_names to existing column_group for sname.oname.

PROCEDURE DBMS_REPCAT.ADD_MASTER_DATABASE (gname IN VARCHAR2, master IN VARCHAR2, use_existing_objects IN BOOLEAN := TRUE, copy_rows IN BOOLEAN := TRUE, comment IN VARCHAR2 := '', propagation_mode IN VARCHAR2 := 'ASYNCHRONOUS', fname IN VARCHAR2 := NULL);

Adds master to gname replication group. use_existing_objects lets you indicate if you want to reuse objects of the same type at the existing master site, copy_rows indicates that you want to copy the contents of a table to the new master site, comment is added to the MASTER_COMMENT column of the DBA_REPSITES view, propagation_mode can be either ASYNCHRONOUS or SYNCHRONOUS, and fname is for internal Oracle use only.

PROCEDURE DBMS_REPCAT.ADD_NEW_MASTERS (export_required IN BOOLEAN, {available_master_list IN VARCHAR2 | available_master_table DBMS_UTILITY.DBLINK_ARRAY}, masterdef_flashback_scn OUT NUMBER, extension_id OUT RAW, break_trans_to_masterdef IN BOOLEAN := FALSE, break_trans_to_new_masters IN BOOLEAN := FALSE, percentage_for_catchup_mdef IN BINARY_INTEGER := 100, cycle_seconds_mdef IN BINARY_INTEGER := 60, percentage_for_catchup_new IN BINARY_INTEGER := 100, cycle_seconds_new IN BINARY_INTEGER := 60);

Adds new master sites to the master groups from the SPECIFY_NEW_MASTERS procedure. ...