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


1 to 40 of 337 results. Previous page Prev  Next next page
Results per page:  20 |  40  | 60


Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Managing Logical Change Records (LCRs)

Executing LCRsThere are separate EXECUTE member procedures for row LCRs and DDL LCRs. These member procedures … row LCRs and DDL LCRs: Executing Row LCRs Executing DDL LCRs

Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Managing Logical Change Records (LCRs)

Constructing and Enqueuing LCRsUse the following LCR constructors to create LCRs: To create a row LCR that contains a change to a … process, because the apply process will be applying persistent LCRs, not captured LCRs. Also, ensure … LCR constructors Create and enqueue LCRs using the construct_row_lcr procedure created in Step 5. In

Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Managing Logical Change Records (LCRs)

Executing Row LCRsThe EXECUTE member procedure for row LCRs is a subprogram of the LCR$_ROW_RECORD type. When the … LCRs\" \"Managing a DML Handler\" for an example of a DML handler that runs the EXECUTE member … procedure on row LCRs Oracle Database PL/SQL Packages and Types Reference for more information about row … LCRs and

Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Managing Logical Change Records (LCRs)

Requirements for Managing LCRsThis section describes requirements for creating or modifying logical change records (LCRs). You … an apply handler or a rule-based transformation. You can modify captured LCRs or persistent LCRs … -constructed row LCR. However, you can use certain techniques to construct LCRs that contain LOB information … .

Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Managing Logical Change Records (LCRs)

Executing DDL LCRsThe EXECUTE member procedure for DDL LCRs is a subprogram of the LCR$_DDL_RECORD type. When the … would be run for the LCR are not run. The EXECUTE member procedure for DDL LCRs can be invoked only … in an apply handler for an apply process. All applied DDL LCRs commit automatically. Therefore, if a … automatically. See Also:

Streams Concepts and Administration, 11g Release 1 (11.1)

Oracle Streams Information Capture

Logical Change Records (LCRs)LCRs: row LCRs and DDL LCRs. A capture process, synchronous capture, or an application can capture … LCRs. You can capture the following types of LCRs with Oracle Streams: A captured LCR is an LCR that … the DBMS_APPLY_ADM package There are no differences between persistent LCRs that

Streams Concepts and Administration, 11g Release 1 (11.1)

XML Schema for LCRs

C XML Schema for LCRsGo to main content 47/51 C XML Schema for LCRs The XML schema described in this appendix defines … for LCRs. The namespace for this schema is the following: http://xmlns.oracle.com/streams/schemas … Definition of the XML Schema for LCRs The following is the XML schema definition for LCRs: '

Streams Concepts and Administration, 11g Release 1 (11.1)

What's New in Oracle Streams?

Track LCRs Through a Stream$STREAMS_MESSAGE_TRACKING view to track the LCRs through the stream and see how they were processed by … each Oracle Streams client. LCR tracking is useful if LCRs are not being applied as expected by one … or more apply processes. When this happens, you can use LCR tracking to determine where the LCRs … message_tracking_frequency

Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Monitoring Oracle Streams Replication

Tracking LCRs Through a Streamcapture database changes implicitly. An application or user can construct and enqueue LCRs to … $STREAMS_MESSAGE_TRACKING view to track the LCRs through the stream and see how they were processed by each Oracle Streams … client. LCR tracking is useful if LCRs are not being applied as expected by one or more apply … processes.

Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Managing Logical Change Records (LCRs)

Managing LCRs Containing LOB ColumnsLOB data types can be present in row LCRs captured by a capture process, but these data types are … represented by other data types. LOB data types cannot be present in row LCRs captured by synchronous … captures. Certain LOB data types cannot be present in row LCRs constructed by users. Table 11-1 … LCRs. Table

Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Understanding Oracle Streams Replication

Apply Processing Options for LCRsAn apply process is a flexible mechanism for processing the logical change records (LCRs) in a … LCRs, not non-LCR user messages. This section discusses the LCR processing options available to you … with an apply process. Captured LCRs and Persistent LCRs A single apply process can apply messages from … contains

Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Managing Logical Change Records (LCRs)

11 Managing Logical Change Records (LCRs)This chapter contains instructions for managing logical change records (LCRs) in an Oracle Streams … replication environment. This chapter contains these topics: Requirements for Managing LCRs … Constructing and Enqueuing LCRs Executing LCRs Managing LCRs Containing LOB Columns Managing LCRs

Streams Replication Administrator's Guide, 11g Release 1 (11.1)

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 1 (11.1)

Managing Logical Change Records (LCRs)

LOB Assembly and Custom Apply of LCRs Containing LOB Columnsa change to a row that includes one or more LOB columns can result in multiple row LCRs. An apply … process that does not send row LCRs that contain LOB columns to an apply handler can apply these row … LCRs directly. However, prior to Oracle Database 10 g Release 2, custom processing of row LCRs that … LCRs

Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Managing Logical Change Records (LCRs)

Example Script for Constructing and Enqueuing LCRs Containing LOBsLCRs containing LOBs. This example assumes that you have prepared your database for Oracle Streams … Necessary Privileges on the Tables Create a PL/SQL Procedure to Enqueue LCRs Containing LOBs Create the … with_blob TO strmadmin; COMMIT; /* Step 8   Create a PL/SQL Procedure to Enqueue LCRs Containing LOBs

Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Managing Logical Change Records (LCRs)

Apply Process Behavior for Direct Apply of LCRs Containing LOBsAn apply process behaves in the following ways when it applies an LCR that contains a LOB column directly (without the use of an apply handler): If an LCR whose command type is INSERT or UPDATE has a new LOB that contains data, and the lob_information is not DBMS_LCR.LOB_CHUNK or DBMS_LCR.LAST_LOB_CHUNK, then the data is applied. If an LCR whose command type is INSERT or UPDATE has a new LOB that

Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Managing Logical Change Records (LCRs)

Managing LCRs Containing LONG or LONG RAW ColumnsLONG and LONG RAW data types all can be present in row LCRs captured by a capture process, but … these data types are represented by the following data types in row LCRs. LONG data type is represented … as VARCHAR2 data type in row LCRs. LONG RAW data type is represented as RAW data type in row LCRs. A … LCRs.

Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Managing Capture, Propagation, and Apply

Creating an ANYDATA Queue to Stage LCRsIn an Oracle Streams replication environment, ANYDATA queues stage LCRs that encapsulate captured

Streams Concepts and Administration, 11g Release 1 (11.1)

Managing Oracle Streams Implicit Capture

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

Streams Concepts and Administration, 11g Release 1 (11.1)

Configuring Implicit Apply

Creating an Apply Process for Captured LCRs: Creates an apply process named strm01_apply that applies captured LCRs to the local database. The apply … system generated. Creates one rule that evaluates to TRUE for row LCRs that contain the results of … apply process. Specifies that the LCRs applied by the apply process originate at the dbs1.example.com

Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Managing Capture, Propagation, and Apply

Creating a Propagation that Propagates LCRsTo replicate LCRs between databases, you must propagate the LCRs from the database where they were … \"Creating an ANYDATA Queue to Stage LCRs\" for instructions. Create a database link between the database … the propagation propagates LCRs from strep01_queue in the current database to strep02_queue in the … propagate

Streams Concepts and Administration, 11g Release 1 (11.1)

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 LCRs Excluding Extra Attributes from Implicitly LCRs See … Also: \"Extra Information in LCRs\" \"Viewing the Extra Attributes Captured by Implicit Capture

Streams Concepts and Administration, 11g Release 1 (11.1)

Managing Oracle Streams Implicit Capture

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

Streams Concepts and Administration, 11g Release 1 (11.1)

Troubleshooting an Oracle Streams Environment

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 1 (11.1)

Troubleshooting an Oracle Streams Environment

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 … from acting on LCRs that are not involved with the error transaction. After successful reexecution

Streams Concepts and Administration, 11g Release 1 (11.1)

Configuring Implicit Apply

Creating an Apply Process for Captured LCRs with DBMS_APPLY_ADMprocess applies captured LCRs, and not persistent LCR s or persistent user message s. Therefore, if an … . Specifies that the LCRs applied by the apply process originate at the dbs1.example.com source

Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Managing Capture, Propagation, and Apply

Creating an Apply Process That Applies Captured LCRschange records (LCRs). Captured LCRs are LCRs that were captured by a capture process. You can use any … of the following procedures to create an apply process that applies captured LCRs … captured LCRs: BEGIN DBMS_STREAMS_ADM.ADD_SCHEMA_RULES( schema_name => 'hr', streams_type => 'apply … strep01_apply

Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Managing Capture, Propagation, and Apply

Creating an Apply Process That Applies Persistent LCRs and User MessagesThis section contains instructions for creating an apply process that applies persistent LCRs and … persistent user messages. Persistent LCRs are row logical change records (row LCRs) that were … DBMS_APPLY_ADM.CREATE_APPLY procedure to create an apply process that applies persistent LCRs and persistent user

Streams Concepts and Administration, 11g Release 1 (11.1)

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 Advanced Queuing User's Guide, 11g Release 1 (11.1)

Using ANYDATA Queues for User Messages

22.6 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

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

Logical Change Record TYPEs

228 Logical Change Record TYPEsThis chapter describes the logical change record (LCR) types. In Oracle Streams, LCRs are message … 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, the apply process can apply LCRs at a … destination

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

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 1 (11.1)

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 1 (11.1)

DBMS_STREAMS_ADM

Overviewdatabase 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

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

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 process. Syntax DBMS_APPLY_ADM.SET_TABLE_INSTANTIATION_SCN … is used on the following types of LCRs: Row LCRs for the table DDL LCRs that have a

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

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 1 (11.1)

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 PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

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 process. Syntax DBMS_APPLY_ADM.SET_SCHEMA_INSTANTIATION_SCN … following types of DDL LCRs: DDL LCRs with a command_type of CREATE TABLE DDL LCRs with a non- NULL

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

DBMS_STREAMS_ADM

Operational Notesmanipulation language (DML) changes made to a table, to logical change records (LCRs), or to user … DDL change is a DDL LCR. LCRs can either represent changes that were captured by a capture process or … LCRs Propagation Rules for User Messages Apply Process Rules for LCRs Apply Process Rules for User … Messages

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

DBMS_STREAMS

129 DBMS_STREAMSwhose rules include specifications for these binary tags in redo entries or LCRs. See Also: Oracle