Oracle® Warehouse Builder OMB*Plus Command Reference 11g Release 2 (11.2) Part Number E14406-01 |
|
|
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
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"
The strategy to be used for synchronization. Must be one of SYNCHRONIZE_STRATEGY OR MATCHING_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.
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.