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
Viewing the Capture Processes for the LCRs in Each Buffered Queue → LCRs 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
Step 5 Create a Procedure that Prints All the Error LCRs for a Transaction → The following procedure prints all the LCRs in the error queue for a particular transaction. It
Step 11 Create the Custom Rule-Based Transformation for Row LCRs at dbs2.example.com → be required for the DDL LCRs. This transformation would need to change the object name and the DDL
ID Key LCRs → and 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
Position of LCRs and XStream Out → An 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
Position of LCRs and XStream In → A 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
LCRs Streaming from an Outbound Server Are Missing Extra Attributes → LCRs 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
SET_MESSAGE_TRACKING Procedure → Sets 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
Overview → In 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,
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.
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
V$STREAMS_TRANSACTION → change 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
Explicit Capture and Transparent Data Encryption → You 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\"
Dependency Detection, Rule-Based Transformations, and Apply Handlers → handlers 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
SET_SCHEMA_INSTANTIATION_SCN Procedure → precise 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
Overview → level. 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
INCLUDE_EXTRA_ATTRIBUTE Procedure → This 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
CONVERT_LCR_TO_XML Function → object 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
V$XSTREAM_TRANSACTION → many 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
Manual Dequeue and Transparent Data Encryption → A user or application can dequeue implicitly captured row LCRs that contain columns encrypted using … transparent data encryption. When row LCRs with encrypted columns are dequeued, the encrypted
5 Logical Change Records with LOBs Example → LCRs that contain LOBs. This chapter contains this topic: Example Script for Constructing and Enqueuing LCRs Containing LOBs
Types of Information Captured with Oracle Streams → The following types of information can be captured with Oracle Streams: Logical Change Records (LCRs) User Messages
DBA_APPLY_ERROR → transaction ERROR_TYPE Foot 1 VARCHAR2(23) NULL if the apply process can access all of the LCRs in the … the LCRs in the error transaction. This error type typically means that the apply process was … applying LCRs in a large transaction. When the ERROR_TYPE is EAGER ERROR, manage the error transaction … apply process can access
ALL_APPLY_ERROR → process can access all of the LCRs in the error transaction. When the ERROR_TYPE is NULL, manage the … ERROR if the apply process cannot access all of the LCRs in the error transaction. This error type … typically means that the apply process was applying LCRs in a large transaction. When the ERROR_TYPE is … . ERROR_POSITION Foot 2
SET_GLOBAL_INSTANTIATION_SCN Procedure → … This procedure gives you precise control over which DDL logical change records (DDL LCRs) from a … source database are ignored and which DDL LCRs are applied by an apply component. Syntax … LCRs The recursive Parameter Considerations for the SET_GLOBAL_INSTANTIATION_SCN Procedure The … SET_TABLE_INSTANTIATION_SCN Procedure
Apply Processes and Transparent Data Encryption → An apply process can dequeue and process implicitly captured row logical change records (row LCRs … ) that contain columns encrypted using transparent data encryption. When row LCRs with encrypted … columns are dequeued by an apply process, the encrypted columns are decrypted. These row LCRs with … . When row LCRs
V$XSTREAM_OUTBOUND_SERVER → displays statistics about an outbound server. An outbound server sends LCRs to the XStream client … -system process that sends LCRs to the client application SERVER_NAME VARCHAR2(30) Name of the outbound … because there are no LCRs to send to the XStream client application. GET TRANSACTIONS - Receiving … XStream client application.
The Source of Messages Applied by an Apply Process → originated at multiple databases. However, a single apply process can apply captured LCRs from only … one source database. Similarly, a single apply process can apply persistent LCRs captured by a … synchronous capture from only one source database. Applying these LCRs requires knowledge of the … LCRs from multiple
Table 4-1 Information Consumption Options with Oracle Streams → Process Continually and automatically when enabled Captured LCRs Persistent LCRs Persistent user messages … You want to dequeue and process captured LCR s. You want to dequeue persistent LCRs or persistent … Messaging Client When invoked by an application Persistent LCRs Persistent user messages You want to use
V$STREAMS_MESSAGE_TRACKING → displays information about LCRs tracked through the stream that are processed by each Streams … LCRs is tracked in memory, and this view is populated with information about the LCRs. Currently
Change Capture in a Non-Oracle to Oracle Environment → LCRs and enqueuing the LCRs at the Oracle database, the application is completely responsible for … change capture. Therefore, the application must construct LCRs that represent changes at the non-Oracle … database and then enqueue these LCRs into the queue at the Oracle database. The application can … the transactions
Propagations and Network Data Encryption → A propagation can propagate row logical change records (row LCRs) that contain changes to columns … that were encrypted using network data encryption. When a propagation propagates row LCRs with … encrypted columns, the encrypted columns are decrypted while the row LCRs are transferred over the network
Queues and Transparent Data Encryption → A persistent queue can store row logical change records (row LCRs) captured by a synchronous … capture, and these row LCRs can contain changes to columns that were encrypted using transparent data … encryption. The row LCRs remain encrypted while they are stored in the persistent queue. Explicitly … captured row LCRs
Synchronous Capture and Transparent Data Encryption → data encryption. Encrypted columns in row logical change records (row LCRs) captured by a synchronous … capture remain encrypted when the row LCRs are staged in a persistent queue. See Also: \"Implicit Capture with Synchronous Capture\"
Viewing the Extra Attributes Captured by Implicit Capture → attributes in LCRs. The following query displays the extra attributes included in the LCRs captured by … ' FORMAT A15 COLUMN INCLUDE HEADING 'Include Attribute in LCRs?' FORMAT A30 SELECT CAPTURE_NAME … the following: Capture Process or Attribute Name Include Attribute in LCRs? Synchronous Capture … includes the
Messaging Clients and Transparent Data Encryption → A messaging client can dequeue implicitly captured row LCRs that contain columns encrypted using … transparent data encryption. When row LCRs with encrypted columns are dequeued by a messaging client
About Combined Capture and Apply Optimization → receiver enqueues the LCRs into the buffered queue portion of the destination queue, and an apply … process dequeues the LCRs. This optimization is called combined capture and apply.
Types of Messages That Can Be Enqueued Explicitly → they can be LCR s. This section contains these topics: User Messages Logical Change Records (LCRs … Change Records (LCRs) and Messaging An application can construct and enqueue LCRs into an ANYDATA … queue. Row LCRs describe the results of DML changes, and DDL LCRs describe DDL changes. Typically, LCRs
Low-Watermark and High-Watermark for an Apply Process → The low-watermark for an apply process is the system change number (SCN) up to which all LCRs have … been applied. That is, LCRs that were committed at an SCN less than or equal to the low-watermark … number have definitely been applied, but some LCRs that were committed with a higher SCN also might … capture process. The high-watermark