Skip to Main Content
Oracle Distributed Systems
book

Oracle Distributed Systems

by Charles Dye
April 1999
Intermediate to advanced content levelIntermediate to advanced
552 pages
15h 39m
English
O'Reilly Media, Inc.
Content preview from Oracle Distributed Systems

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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Expert Oracle RAC 12c

Expert Oracle RAC 12c

Syed Jaffar Hussain, Tariq Farooq, Riyaj Shamsudeen, Kai Yu
Expert Oracle Exadata, Second Edition

Expert Oracle Exadata, Second Edition

Martin Bach, Karl Arao, Andy Colvin, Frits Hoogland, Randy Johnson, Kerry Osborne, Tanel Poder

Publisher Resources

ISBN: 1565924320Supplemental ContentCatalog PageErrata