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

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

OMBMOVE

Purpose

Move one or more objects of the same object type. The replace option allows you to overwrite.

Prerequisites

Use of relative path specifications requires awareness of the current context.

Syntax

parseMoveCommand =  OMBMOVE "moveObjectType" "QUOTED_STRING" { ( OPERATOR |
           GROUP | ATTRIBUTE ) "QUOTED_STRING" } TO "QUOTED_STRING" { ( OPERATOR
           | GROUP | ATTRIBUTE ) "QUOTED_STRING" } [ USE REPLACE_MODE ]
     moveObjectType =  ( "UNQUOTED_STRING" )

Parameters

parseMoveCommand

Specifies the source object type, source path, and target path for the object to move. Moving objects is subject to the following restrictions: 1. You can only move objects within the current project; you cannot move objects between projects. 2. You cannot move an object within the same parent folder; if your purpose is to rename the object, use the 'OMBALTER...RENAME TO...' command.

QUOTED_STRING

Source and target path specifications can be absolute or relative. To move multiple objects, include a regular expression as the final step of the source path. If you are moving multiple objects, the final step of the target path must be the folder to which the objects are being copied. If you are only moving one object, you can specify the object's original name or a new name as the final step of the target path.

REPLACE_MODE

Use this option to overwrite existing target objects.

moveObjectType

The type of the object(s) to be copied. Valid types are: PROJECT, ORACLE_MODULE, FLAT_FILE_MODULE, BUSINESS_DEFINITION_MODULE, OBIEE_BUSINESS_DEFINITION_MODULE, BUSINESS_PRESENTATION_MODULE, SAP_MODULE, CMI_MODULE, PROCESS_FLOW_MODULE, PROCESS_FLOW_PACKAGE, PROCESS_FLOW, EXPERT_MODULE, EXPERT, CT, CT_FOLDER, FLAT_FILE, ADVANCED_QUEUE, STREAMS_QUEUE, QUEUE_TABLE, QUEUE_PROPAGATION, STREAMS_CAPTURE_PROCESS, OBJECT_TYPE, VARYING_ARRAY, NESTED_TABLE, TABLE, VIEW, MATERIALIZED_VIEW, SEQUENCE, DIMENSION, CUBE, DATA_AUDITOR, DATA_PROFILE, DATA_RULE, DATA_RULE_MODULE, MAPPING, REAL_TIME_MAPPING, PACKAGE, FUNCTION, TABLE_FUNCTION, PROCEDURE, BUSINESS_AREA, COLLECTION, EXTERNAL_TABLE, REGISTERED_FUNCTION, ITEM_FOLDER, DRILL_PATH, LIST_OF_VALUES, DRILL_TO_DETAIL, ALTERNATIVE_SORT_ORDER, PRESENTATION_TEMPLATE and any user defined object types.

See Also

OMBCOPY