Name
DBMS_REPCAT.VALIDATE
Synopsis
The VALIDATE function diagnoses the status of your replicated environment and returns any errors in either a PL/SQL array of records (error_table) or a pair of arrays with error text (error_msg_table) and error numbers (error_num_table).
FUNCTION validate(gname IN VARCHAR2,
check_genflags IN BOOLEAN := FALSE,
check_valid_objs IN BOOLEAN := FALSE,
check_links_sched IN BOOLEAN := FALSE,
check_links IN BOOLEAN := FALSE,
error_table OUT dbms_repcat.validate_err_table)
FUNCTION validate(gname IN VARCHAR2,
check_genflags IN BOOLEAN := FALSE,
check_valid_objs IN BOOLEAN := FALSE,
check_links_sched IN BOOLEAN := FALSE,
check_links IN BOOLEAN := FALSE,
error_msg_table OUT dbms_utility.uncl_array,
error_num_table OUT dbms_utility.number_array)
RETURN BINARY_INTEGER;The return value of these functions is the number of errors detected.
There are no restrictions on calling this function.
Parameters
Parameter Name | Description |
|---|---|
gname | Name of the replication group. |
check_genflags | Boolean flag indicating whether to check that all replicated objects have replication support generated. |
check_valid_objs | Boolean flag which checks whether or not all replicated objects are valid. This check is performed at all master sites. |
check_links_sched | Boolean flag to check if pushes are scheduled to all master databases. |
check_links | Boolean flag which checks if the user invoking the procedure has valid database links to all master databases. |
error_table | PL/SQL table of errors found. |
error_msg_table ... |