Results for LCRs


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


Streams Replication Administrator's Guide, 11g Release 2 (11.2)

Managing Logical Change Records (LCRs)

Step 5   Query the DBA_APPLY_DML_HANDLERS ViewTo ensure that the procedure DML handler is set properly for the oe.product_information table, run the following query: COLUMN OBJECT_OWNER HEADING 'Table|Owner' FORMAT A5 COLUMN OBJECT_NAME HEADING 'Table Name' FORMAT A20 COLUMN OPERATION_NAME HEADING 'Operation' FORMAT A10 COLUMN USER_PROCEDURE HEADING 'Handler Procedure' FORMAT A25 COLUMN ASSEMBLE_LOBS HEADING 'LOB Assembly?' FORMAT A15 SELECT

Streams Replication Administrator's Guide, 11g Release 2 (11.2)

Managing Logical Change Records (LCRs)

Requirements for Constructing and Processing LCRs Containing LOB ColumnsIf your environment produces row LCRs that contain LOB columns, then you must meet the requirements … in the following sections when you construct or process these LCRs: Requirements for Constructing … and Processing LCRs Without LOB Assembly Requirements for Apply Handler Processing of LCRs with LOB … Assembly

Streams Replication Administrator's Guide, 11g Release 2 (11.2)

Managing Logical Change Records (LCRs)

Table 14-1 LOB Data Type Representations in Row LCRsapplied as several row LCRs. Rules used to evaluate these row LCRs must be deterministic, so that either … all of the row LCRs corresponding to the row change cause a rule in a rule set to evaluate to TRUE … when constructing or processing LOB columns, about apply process behavior for LCRs containing LOB … columns,

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

Managing Oracle Streams Implicit Capture

Managing Extra Attributes in Captured LCRsit is capturing currently. The extra attributes are the following: row_id (row LCRs only) serial … : Including Extra Attributes in Implicitly Captured LCRs Excluding Extra Attributes from Implicitly … Captured LCRs See Also: \"Extra Information in LCRs\" \"Viewing the Extra Attributes Captured by

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

Managing Oracle Streams Implicit Capture

Including Extra Attributes in Implicitly Captured LCRsTo include an extra attribute in the LCRs captured by a capture process or synchronous capture, run

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

Troubleshooting Apply

Does the Apply Process Apply Captured LCRs?= 'APPLY'; If the apply process applies captured LCRs, then your output looks similar to the

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

Managing Oracle Streams Implicit Capture

Excluding Extra Attributes from Implicitly Captured LCRsTo exclude an extra attribute from the LCRs captured by a capture process or synchronous capture

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

Oracle Streams Information Capture

Table 2-5 Extra Attributes in LCRsincluded in DDL LCRs or row LCRs for index-organized tables. serial# The serial number of the session … Captured LCRs\" \"Viewing the Extra Attributes Captured by Implicit Capture\" Oracle Database PL/SQL

Streams Replication Administrator's Guide, 11g Release 2 (11.2)

Configuring Implicit Apply

Creating an Apply Process for Captured LCRs with DBMS_APPLY_ADMapply process that applies captured logical change records (LCRs). This apply process can apply LCRs … process applies captured LCRs, not persistent LCRs or persistent user messages. Therefore, if an LCR that … use a negative rule set. Specifies that the LCRs applied by the apply process originate at

Streams Replication Administrator's Guide, 11g Release 2 (11.2)

Configuring Implicit Apply

Creating an Apply Process for Persistent LCRs with DBMS_APPLY_ADMapply process that applies persistent logical change records (LCRs). This apply process can apply LCRs … captured LCRs. Therefore, the apply process can apply persistent LCRs or persistent user messages … rules to the apply process rule set. These rules direct the apply process to apply LCRs for the

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

Oracle Streams Information Capture

Table 2-3 Attributes Present in All DDL LCRs… edition_name The name of the edition in which the DDL statement was executed. DDL LCRs that were captured by … . Synchronous captures cannot capture DDL changes, and these attributes are not present in explicitly captured DDL LCRs.

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

Oracle Streams Information Capture

Table 2-4 Additional Attributes in Captured DDL LCRsrow LCRs and DDL LCRs contain the source database name of the database where a change originated. If … PL/SQL Packages and Types Reference Extra Information in LCRs In addition to the information … discussed in the previous sections, row LCRs and DDL LCRs optionally can include the extra information

Streams Extended Examples, 11g Release 2 (11.2)

Logical Change Records with LOBs Example

Example Script for Constructing and Enqueuing LCRs Containing LOBsAdministrator Necessary Privileges on the Tables Create a PL/SQL Procedure to Enqueue LCRs Containing LOBs

Streams Advanced Queuing User's Guide, 11g Release 2 (11.2)

Using ANYDATA Queues for User Messages

Propagating User-Enqueued LCRs from ANYDATA Queues to Typed QueuesYou can propagate user-enqueued LCRs to an appropriate typed queue, but propagation of captured … LCRs to a typed queue is not supported. See Also: \"Streams Capture Process\" in Oracle Streams … Concepts and Administration for more information on capture processes To propagate user-enqueued LCRs from … package to transform LCRs

Streams Replication Administrator's Guide, 11g Release 2 (11.2)

Configuring Implicit Apply

Creating an Apply Process for Captured LCRs Using DBMS_STREAMS_ADMan apply process that applies captured logical change records (LCRs). This apply process can apply … LCRs that were captured by a capture process. Complete the following steps: Complete the tasks in … LCRs to the local database. The apply process is created only if it does not already exist … that evaluates to TRUE for row LCRs

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

Oracle Streams Information Capture

Table 2-1 Attributes Present in All Row LCRsINSERT, then there are no old values. For UPDATE and DELETE statements, row LCRs created by a capture … process can include some or all of the old column values in the row, but row LCRs created by a … no new values. For UPDATE and INSERT statements, row LCRs created by a capture process can include … some or all of the new column

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

Troubleshooting Rules and Rule-Based Transformations

Are Incorrectly Transformed LCRs in the Error Queue?In some cases, incorrectly transformed LCRs might have been moved to the error queue by an apply … DML handler from acting on LCRs that are not involved with the error transaction. After successful

Database XStream Guide, 11g Release 2 (11.2)

XStream Concepts

Sequence LCRsgenerate sequence values. You can stream sequence LCRs in the following ways: To capture sequence … LCRs using a capture process, set the capture process parameter capture_sequence_nextval to Y. To … construct sequence LCRs using the OCI interface, use the OCILCRNew function and the OCILCRHeaderSet … function with the OCI_ROWLCR_SEQ_LCR

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

Monitoring Oracle Streams Apply Processes

Step 4   Create a Procedure that Prints All the LCRs in the Error QueueThe following procedure prints all of the LCRs in all of the error queues. It calls the print_lcr

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

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