Results for LCRs


21 to 40 of 507 results. Prev  Next
Results per page:   20  | 40 | 60


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)

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)

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

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

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)

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


Was this page helpful?