You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for LCRs


21 to 80 of 507 results. previous page Prev  Next next page
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 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 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 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 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 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)

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)

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

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)

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

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

DBMS_STREAMS_HANDLER_ADM

Overviewchange records (row LCRs) that are dequeued by an apply process. A single statement DML handler can … procedure DML handlers provide custom processing of row changes that are encapsulated in row LCRs … in row LCRs. Typically, procedure DML handlers must manipulate ANYDATA values. A statement DML