Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from 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. ...

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
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page