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_LOGSTNDBY.APPLY_SET (parameter IN VARCHAR2, value IN VARCHAR2);

Lets you set parameter to value. For more information on the parameters that can be set, see the Oracle documentation.

PROCEDURE DBMS_LOGSTDBY.APPLY_UNSET (parameter IN VARCHAR);

Reverses the values applied with the APPLY_SET procedure.

PROCEDURE DBMS_LOGSTDBY.BUILD;

Used to preserve LogMiner dictionary information in the redo logs.

PROCEDURE DBMS_LOGSTDBY.GUARD_BYPASS_OFF;

Reenables the database guard feature that was previously bypassed with the GUARD_BYPASS_ON procedure.

PROCEDURE DBMS_LOGSTDBY.GUARD_BYPASS_ON;

Turns off the database guard that protects the logical standby from modifications. Typically used for maintenance or problem correction on the standby, but not for transactions, because triggers and constraints are not used.

PROCEDURE DBMS_LOGSTDBY.INSTANTIATE_TABLE (table_name IN VARCHAR2, schema IN VARCHAR2, dblink IN VARCHAR2);

Creates table_name in schema of dblink.

PROCEDURE DBMS_LOGSTDBY.SKIP (statement_option IN VARCHAR2, schema_name IN VARCHAR2, object_name IN VARCHAR2, proc_name IN VARCHAR2);

Defines filter, defined by keywords in statement_option, to prevent certain SQL statements on object_name in schema_name from being applied to the logical standby database, based on rules defined in proc_name.

PROCEDURE DBMS_LOGSTDBY.SKIP_ERROR (statement_option IN VARCHAR2, schema_name IN VARCHAR2, object_name IN VARCHAR2, proc_name IN VARCHAR2);

Called when log apply services encounter ...

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