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 20 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)

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 2 (11.2)

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 … Administration Oracle Database PL/SQL Packages and Types Reference for more information about row LCRs and … the LCR$_ROW_RECORD type Example of Constructing and Executing Row LCRs The example in this section … and executing row LCRs.

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

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 2 (11.2)

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 … Reference for more information

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

Oracle Streams Information Capture

Logical Change Records (LCRs)LCRs: row LCRs and DDL LCRs. A capture process, a 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 … in the DBMS_APPLY_ADM package The only difference between the persistent LCRs captured

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

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 Concepts and Administration, 11g Release 2 (11.2)

XML Schema for LCRs

C XML Schema for LCRsGo to main content 53/57 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 Replication Administrator's Guide, 11g Release 2 (11.2)

Managing Oracle Streams Replication

Tracking LCRs Through a Streamcapture database changes implicitly. An application or user can construct and enqueue LCRs to … LCR through a stream using one of the following methods: When LCRs are captured by a capture … low value. When LCRs are captured by a capture process or a synchronous capture, or when LCRs are … package. LCR tracking

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

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 2 (11.2)

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 14-1 … shows the LCR representation

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

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, before Oracle Database 10 g Release 2, custom processing of row LCRs that … LCRs

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

Managing Logical Change Records (LCRs)

14 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 2 (11.2)

Managing Logical Change Records (LCRs)

Table 14-3 Oracle Streams Behavior with LOB Assembly EnabledSET_VALUES member procedures for row LCRs to make changes to a LOB. When LOB assembly is enabled, LOB … assembly converts non- NULL LOB columns in persistent LCRs into LOB locators. However, LOB assembly … does not combine multiple persistent row LCRs into a single row LCR. For example, for persistent row … LCRs,

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

Managing Logical Change Records (LCRs)

Step 2   Add the product_long_desc Column to the product_information TableThe following statement adds the product_long_desc column to the product_information table at all of the databases in the environment: ALTER TABLE oe.product_information ADD(product_long_desc CLOB);

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

Managing Logical Change Records (LCRs)

Step 3   Create the PL/SQL Procedure for the Procedure DML HandlerThis example creates the convert_product_information procedure. This procedure will be used for the procedure DML handler. This procedure assumes that the following user-created PL/SQL subprograms exist: The get_photo procedure obtains a photo in BLOB format from a URL or table based on the product_id and updates the BLOB locator that has been passed in as an argument. The get_product_long_desc procedure

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

Managing Logical Change Records (LCRs)

Step 4   Set the Procedure DML Handler for the Apply ProcessThis step sets the convert_product_information procedure as the procedure DML handler at the destination database for INSERT, UPDATE, and LOB_UPDATE operations. Notice that the assemble_lobs parameter is set to TRUE each time the SET_DML_HANDLER procedure is run. BEGIN DBMS_APPLY_ADM.SET_DML_HANDLER( object_name => 'oe.product_information', object_type => 'TABLE', operation_name => 'INSERT', error_handler

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

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 2 (11.2)

Managing Logical Change Records (LCRs)

Table 14-2 Oracle Streams Behavior with LOB Assembly DisabledOriginal Row Change First Set of LCRs Second Set of LCRs Third Set of LCRs Final LCR INSERT One … INSERT LCR One or more LOB WRITE LCRs One or more LOB TRIM LCRs UPATE UPDATE One UPDATE LCR One or more … LOB WRITE LCRs One or more LOB TRIM LCRs UPATE DELETE One DELETE

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

Managing Logical Change Records (LCRs)

Step 1   Add the photo Column to the product_information TableThe following statement adds the photo column to the product_information table at the destination database: ALTER TABLE oe.product_information ADD(photo BLOB);

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

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