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 40 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