Results for LCRs


41 to 60 of 507 results. Prev  Next
Results per page:   20  | 40 | 60


Streams Extended Examples, 11g Release 2 (11.2)

Logical Change Records with LOBs Example

Step 8   Create a PL/SQL Procedure to Enqueue LCRs Containing LOBs*/ CONNECT strmadmin CREATE OR REPLACE PROCEDURE enq_row_lcr(source_dbname VARCHAR2, cmd_type VARCHAR2, obj_owner VARCHAR2, obj_name VARCHAR2, old_vals SYS.LCR$_ROW_LIST, new_vals SYS.LCR$_ROW_LIST) AS xr_lcr SYS.LCR$_ROW_RECORD; BEGIN xr_lcr:= SYS.LCR$_ROW_RECORD.CONSTRUCT( source_database_name => source_dbname, command_type => cmd_type, object_owner => obj_owner, object_name => obj_name, old_values

Streams Concepts and Administration, 11g Release 2 (11.2)

Monitoring Oracle Streams Queues and Propagations

Viewing the Capture Processes for the LCRs in Each Buffered QueueLCRs can be propagated to other queues subsequently. By querying the V$BUFFERED_PUBLISHERS dynamic … performance view, you can display each capture process that captured the LCRs in the buffered queue … . These LCRs might have been captured at the local database, or they might have been captured at a … that the buffered queues

Streams Concepts and Administration, 11g Release 2 (11.2)

Monitoring Oracle Streams Apply Processes

Step 5   Create a Procedure that Prints All the Error LCRs for a TransactionThe following procedure prints all the LCRs in the error queue for a particular transaction. It

Streams Extended Examples, 11g Release 2 (11.2)

Single-Source Heterogeneous Replication Example

Step 11   Create the Custom Rule-Based Transformation for Row LCRs at dbs2.example.combe required for the DDL LCRs. This transformation would need to change the object name and the DDL

Database XStream Guide, 11g Release 2 (11.2)

XStream Concepts

ID Key LCRsand the outbound server are enabled, data changes, encapsulated in row LCRs and DDL LCRs, are sent to … the outbound server. The outbound server can publish LCRs in various formats, such as OCI and Java … . The client application can process LCRs that are passed to it from the outbound server or wait for … LCRs

Database XStream Guide, 11g Release 2 (11.2)

XStream Concepts

Position of LCRs and XStream OutAn XStream Out outbound server streams LCRs that were captured by a capture process to a client … . Additional LCR Attributes Related to Position LCRs that were captured by a capture process contain the … present in row LCRs captured by a synchronous capture nor in explicitly captured row LCRs. See Also … processed

Database XStream Guide, 11g Release 2 (11.2)

XStream Concepts

Position of LCRs and XStream InA client application streams LCRs to an XStream In inbound server. This section describes concepts … positions are important for inbound servers: The applied low position indicates that the LCRs less than … indicates that the LCRs with positions less than or equal to this value have either been applied or … longer requires any

Database XStream Guide, 11g Release 2 (11.2)

Troubleshooting XStream

LCRs Streaming from an Outbound Server Are Missing Extra AttributesLCRs streaming from an outbound server are expected to include extra attributes, but these … attributes are not included in the LCRs. LCRs can contain the following extra attributes related to database … capture these extra attributes. If you want extra attributes to be included in LCRs streamed from an … outbound

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

DBMS_STREAMS_ADM

SET_MESSAGE_TRACKING ProcedureSets the tracking label for logical change records (LCRs) produced by the current session. This … procedure affects only the current session. Any LCRs produced by the current session are tracked … , including captured LCRs and persistent LCRs. Note: The tracking label set by this procedure does not … Description

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

Logical Change Record TYPEs

OverviewIn Oracle Streams, logical change records (LCRs) are message payloads that contain information … ) changes. When you use Oracle Streams, the capture process captures changes in the form of LCRs and … enqueues them into a queue. These LCRs can be propagated from a queue in one database to a queue in … another database. Finally,

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

DBMS_STREAMS

CONVERT_XML_TO_LCR Function(LCRs) into an LCR encapsulated in a ANYDATA object. The LCR can be a row or DDL LCR. See Also: Oracle … Streams Concepts and Administration for more information about the XML schema for LCRs Syntax … object does not conform to XML schema for LCRs, then the function raises an exception.

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

DBMS_APPLY_ADM

SET_TABLE_INSTANTIATION_SCN Procedure… This procedure gives you precise control over which logical change records (LCRs) for a table are … ignored and which LCRs are applied by an apply component. Syntax … and LCRs The SET_TABLE_INSTANTIATION_SCN Procedure and XStream Outbound Servers The … SET_TABLE_INSTANTIATION_SCN Procedure and XStream Inbound Servers

Database Reference, 11g Release 2 (11.2)

V$STREAMS_TRANSACTION

V$STREAMS_TRANSACTIONchange records (LCRs) are being processed in each transaction. This view only contains information … about captured LCRs. It does not contain information about user-enqueued LCRs or user messages. This … view only shows information about LCRs that are being processed because they satisfied the rule … information

Streams Concepts and Administration, 11g Release 2 (11.2)

How Oracle Streams Works with Other Database Components

Explicit Capture and Transparent Data EncryptionYou can use explicit capture to construct and enqueue row logical change records (row LCRs) for … when you construct the row LCRs. Therefore, when explicitly captured row LCRs are staged in a queue … , all of the columns in the row LCRs are decrypted. See Also: \"Explicit Capture by Applications\"

Streams Concepts and Administration, 11g Release 2 (11.2)

Advanced Apply Process Concepts

Dependency Detection, Rule-Based Transformations, and Apply Handlershandlers are configured for the apply process, LCRs are processed in the following order: The apply process … dequeues LCRs from its queue. The apply process runs rule-based transformations on LCRs, when … appropriate. The apply process detects dependencies between LCRs. The apply process passes LCRs

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

DBMS_APPLY_ADM

SET_SCHEMA_INSTANTIATION_SCN Procedureprecise control over which DDL logical change records (LCRs) for a schema are ignored and which DDL … LCRs are applied by an apply component. Syntax DBMS_APPLY_ADM.SET_SCHEMA_INSTANTIATION_SCN … Procedure and LCRs Instantiation SCNs and DDL LCRs The recursive Parameter The … Procedure LCR$_DDL_RECORD Type for

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

DBMS_STREAMS_ADM

Overviewlevel. These rules support logical change records (LCRs), which include row LCRs and data definition … language (DDL) LCRs. This package also contains subprograms for creating message rules for specific

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

DBMS_CAPTURE_ADM

INCLUDE_EXTRA_ATTRIBUTE ProcedureThis procedure includes or excludes an extra attribute in logical change records (LCRs) captured by … included in or excluded from LCRs captured by the capture process or synchronous capture. The following … included in DDL LCRs, or in row LCRs for index-organized tables. The type is VARCHAR2. serial# The serial

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

DBMS_STREAMS

CONVERT_LCR_TO_XML Functionobject that conforms to the XML schema for LCRs. The LCR can be a row LCR or a DDL LCR. See Also … : Oracle Streams Concepts and Administration for more information about the XML schema for LCRs Syntax

Database Reference, 11g Release 2 (11.2)

V$XSTREAM_TRANSACTION

V$XSTREAM_TRANSACTIONmany LCRs are being processed in each transaction. This view only contains information about captured … LCRs. It does not contain information about user-enqueued LCRs or user messages. This view only shows … information about LCRs that are being processed because they satisfied the rule sets for the … in transactions





Was this page helpful?

Integrated Cloud Applications & Platform Services