Results for LCRs


41 to 80 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

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

How Oracle Streams Works with Other Database Components

Manual Dequeue and Transparent Data EncryptionA 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

Streams Extended Examples, 11g Release 2 (11.2)

Logical Change Records with LOBs Example

5 Logical Change Records with LOBs ExampleLCRs that contain LOBs. This chapter contains this topic: Example Script for Constructing and Enqueuing LCRs Containing LOBs

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

Oracle Streams Information Capture

Types of Information Captured with Oracle StreamsThe following types of information can be captured with Oracle Streams: Logical Change Records (LCRs) User Messages

Database Reference, 11g Release 2 (11.2)

DBA_APPLY_ERROR

DBA_APPLY_ERRORtransaction 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

Database Reference, 11g Release 2 (11.2)

ALL_APPLY_ERROR

ALL_APPLY_ERRORprocess 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 

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

DBMS_APPLY_ADM

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

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

How Oracle Streams Works with Other Database Components

Apply Processes and Transparent Data EncryptionAn 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

Database Reference, 11g Release 2 (11.2)

V$XSTREAM_OUTBOUND_SERVER

V$XSTREAM_OUTBOUND_SERVERdisplays 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.

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

Oracle Streams Information Consumption

The Source of Messages Applied by an Apply Processoriginated 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

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

Oracle Streams Information Consumption

Table 4-1 Information Consumption Options with Oracle StreamsProcess 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

Database Reference, 11g Release 2 (11.2)

V$STREAMS_MESSAGE_TRACKING

V$STREAMS_MESSAGE_TRACKINGdisplays 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

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

Oracle Streams Heterogeneous Information Sharing

Change Capture in a Non-Oracle to Oracle EnvironmentLCRs 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

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

How Oracle Streams Works with Other Database Components

Propagations and Network Data EncryptionA 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

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

How Oracle Streams Works with Other Database Components

Queues and Transparent Data EncryptionA 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

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

How Oracle Streams Works with Other Database Components

Synchronous Capture and Transparent Data Encryptiondata 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\"

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

Monitoring Oracle Streams Implicit Capture

Viewing the Extra Attributes Captured by Implicit Captureattributes 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

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

How Oracle Streams Works with Other Database Components

Messaging Clients and Transparent Data EncryptionA 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

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

Combined Capture and Apply Optimization

About Combined Capture and Apply Optimizationreceiver 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.

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

Oracle Streams Information Capture

Types of Messages That Can Be Enqueued Explicitlythey 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

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

Advanced Apply Process Concepts

Low-Watermark and High-Watermark for an Apply ProcessThe 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





Was this page helpful?

Integrated Cloud Applications & Platform Services