December 2002
Intermediate to advanced
928 pages
85h 29m
English
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. ...