Skip Headers
Oracle® Warehouse Builder OMB*Plus Command Reference
11g Release 2 (11.2)

Part Number E14406-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
Mobi · ePub

OMBSYNCHRONIZE

Purpose

Synchronize the target metadata definition with the source metadata definition.

Prerequisites

1. The current context of scripting must be a project at least.

2. The target and/or source objects should exist in the current project.

3. No concurrent user is operating on the target.

Valid synchronize source types for MAPPING:

MAPPING_ACTIVITY

Valid synchronize source types for CONSTRUCT_OBJECT_OPERATOR:

OBJECT_TYPE PLSQL_RECORD_TYPE PLSQL_REF_CURSOR_TYPE

Valid synchronize source types for CUBE_OPERATOR:

CUBE

Valid synchronize source types for DATA_AUDITOR_ACTIVITY:

DATA_AUDITOR

Valid synchronize source types for DIMENSION_OPERATOR:

DIMENSION

Valid synchronize source types for EXPAND_OBJECT_OPERATOR:

OBJECT_TYPE PLSQL_RECORD_TYPE

Valid synchronize source types for EXTERNAL_TABLE:

EXTERNAL_TABLE_OPERATOR RECORD

Valid synchronize source types for EXTERNAL_TABLE_OPERATOR:

EXTERNAL_TABLE FLAT_FILE

Valid synchronize source types for FLAT_FILE:

FLAT_FILE_OPERATOR

Valid synchronize source types for FLAT_FILE_OPERATOR:

FLAT_FILE MATERIALIZED_VIEW TABLE VIEW

Valid synchronize source types for FUNCTION:

TRANSFORMATION_ACTIVITY

Valid synchronize source types for ITERATOR_OPERATOR:

NESTED_TABLE VARYING_ARRAY

Valid synchronize source types for KEY_LOOKUP_OPERATOR:

DIMENSION LEVEL MATERIALIZED_VIEW TABLE VIEW

Valid synchronize source types for LCRCAST_OPERATOR:

TABLE

Valid synchronize source types for MAPPING_ACTIVITY:

MAPPING

Valid synchronize source types for MATERIALIZED_VIEW:

MATERIALIZED_VIEW_OPERATOR

Valid synchronize source types for MATERIALIZED_VIEW_OPERATOR:

FLAT_FILE MATERIALIZED_VIEW TABLE VIEW

Valid synchronize source types for PLUGGABLE_MAPPING:

PLUGGABLE_MAPPING_OPERATOR

Valid synchronize source types for PLUGGABLE_MAPPING_OPERATOR:

PLUGGABLE_MAPPING

Valid synchronize source types for POSTMAPPING_PROCESS_OPERATOR:

FUNCTION PROCEDURE

Valid synchronize source types for PREMAPPING_PROCESS_OPERATOR:

FUNCTION PROCEDURE

Valid synchronize source types for PROCEDURE:

TRANSFORMATION_ACTIVITY

Valid synchronize source types for PROCESS_FLOW:

SUBPROCESS_ACTIVITY

Valid synchronize source types for REGISTERED_FUNCTION:

TRANSFORMATION_ACTIVITY

Valid synchronize source types for SEQUENCE_OPERATOR:

SEQUENCE

Valid synchronize source types for SUBPROCESS_ACTIVITY:

PROCESS_FLOW

Valid synchronize source types for TABLE:

CUBE DIMENSION LEVEL TABLE_OPERATOR

Valid synchronize source types for TABLE_FUNCTION:

TRANSFORMATION_ACTIVITY

Valid synchronize source types for TABLE_OPERATOR:

FLAT_FILE MATERIALIZED_VIEW PROFILE_REFERENCE TABLE VIEW

Valid synchronize source types for TRANSFORMATION_ACTIVITY:

FUNCTION

Valid synchronize source types for TRANSFORMATION_OPERATOR:

FUNCTION PROCEDURE

Valid synchronize source types for VIEW:

VIEW_OPERATOR

Valid synchronize source types for VIEW_OPERATOR:

FLAT_FILE MATERIALIZED_VIEW TABLE VIEW

Syntax

ReconcileCommand =  ( OMBRECONCILE | OMBSYNCHRONIZE ) ( "parseIOObject" | 
          "parseSourceFCOSCO" TO "parseTargetFCOSCO" USE "(" "setStrategyClause"
           "," "setStrategyClause" ")" )
     parseIOObject =  ITEM_FOLDER "QUOTED_STRING" | LOGICAL_TABLE 
          "QUOTED_STRING"
     parseSourceFCOSCO =  ( ( DATA_AUDITOR "QUOTED_STRING" [ OPERATOR 
          "QUOTED_STRING" ] ) ) | ( ( MAPPING "QUOTED_STRING" [ OPERATOR 
          "QUOTED_STRING" ] ) ) | ( ( PLUGGABLE_MAPPING "QUOTED_STRING" [ 
          OPERATOR "QUOTED_STRING" ] ) ) | ( ( REAL_TIME_MAPPING "QUOTED_STRING"
           [ OPERATOR "QUOTED_STRING" ] ) ) | ( ( FLAT_FILE "QUOTED_STRING" [ 
          RECORD "QUOTED_STRING" ] ) ) | ( PROCESS_FLOW "QUOTED_STRING" [ 
          ACTIVITY "QUOTED_STRING" ] ) | ( DIMENSION "QUOTED_STRING" [ LEVEL 
          "QUOTED_STRING" ] ) | ( TABLE | EXTERNAL_TABLE | VIEW | 
          MATERIALIZED_VIEW | SEQUENCE | CUBE | ADVANCED_QUEUE | OBJECT_TYPE | 
          VARYING_ARRAY | NESTED_TABLE | ACTIVITY_TEMPLATE | PACKAGE | FUNCTION 
          | TABLE_FUNCTION | WEB_SERVICE | PROCEDURE ) "QUOTED_STRING"
     parseTargetFCOSCO =  ( ( DATA_AUDITOR "QUOTED_STRING" [ OPERATOR 
          "QUOTED_STRING" ] ) ) | ( ( MAPPING "QUOTED_STRING" [ OPERATOR 
          "QUOTED_STRING" [ GROUP "QUOTED_STRING" ] ] ) ) | ( ( 
          PLUGGABLE_MAPPING "QUOTED_STRING" [ OPERATOR "QUOTED_STRING" ] ) ) | (
           ( REAL_TIME_MAPPING "QUOTED_STRING" [ OPERATOR "QUOTED_STRING" ] ) ) 
          | ( ( FLAT_FILE "QUOTED_STRING" [ RECORD "QUOTED_STRING" ] ) ) | ( ( 
          PROCESS_FLOW "QUOTED_STRING" [ ACTIVITY "QUOTED_STRING" ] ) ) | ( 
          TABLE | EXTERNAL_TABLE | VIEW | MATERIALIZED_VIEW | SEQUENCE | 
          ADVANCED_QUEUE | VARYING_ARRAY | NESTED_TABLE | OBJECT_TYPE | 
          ACTIVITY_TEMPLATE | WEB_SERVICE | FUNCTION | PROCEDURE ) 
          "QUOTED_STRING"
     setStrategyClause =  ( RECONCILE_STRATEGY | SYNCHRONIZE_STRATEGY ) 
          "retrieveReconcileStrategyClause" | MATCHING_STRATEGY 
          "retrieveMatchingStrategyClause"
     retrieveReconcileStrategyClause =  "QUOTED_STRING"
     retrieveMatchingStrategyClause =  "QUOTED_STRING"

Parameters

ReconcileCommand

Synchronizes the target metadata definition with the source metadata definition.

parseIOObject

The source object for synchronization.

parseSourceFCOSCO

The source object for synchronization.

parseTargetFCOSCO

The target object for synchronization.

setStrategyClause

The strategy to be used for synchronization. Must be one of SYNCHRONIZE_STRATEGY OR MATCHING_STRATEGY

SYNCHRONIZE_STRATEGY

MERGE or REPLACE.

MERGE : Updates the matching objects in the target with the metadata definition in the source object and creates new objects in the target for source objects that do not match.

REPLACE : Updates the matching objects in the target with the metadata definition in the source object, creates a new object in the target for source objects that do not match, and deletes objects in the target that have no match in the source.

MATCHING_STRATEGY

Indicates the matching strategy to be used between the object types in source and target. Currently, the list of available matching strategies for a source and target combination are listed below. For synchronization between RECORD and EXTERNAL_TABLE, the valid matching strategies are MATCH_BY_OBJECT_ID, MATCH_BY_OBJECT_NAME, MATCH_BY_OBJECT_POSITION. For synchronization involving OPERATOR of MAP, the available matching strategies are MATCH_BY_OBJECT_ID, MATCH_BY_OBJECT_NAME, MATCH_BY_OBJECT_POSITION, MATCH_BY_OBJECT_ID_AND_NAME, MATCH_BY_OBJECT_ID_AND_POSITION, MATCH_BY_OBJECT_NAME_AND_POSITION, MATCH_BY_OBJECT_ID_AND_NAME_AND_POSITION. Note that the source map might be modified during outbound synchronization of maps, which would require locking both the source and the target before synchronization invocation.

retrieveReconcileStrategyClause

Must of one of 'MERGE' or 'REPLACE'

retrieveMatchingStrategyClause

String representing the matching paradigm between the source and the target object. The list varies for every source and target object type.