Oracle® Warehouse Builder OMB*Plus Command Reference 11g Release 2 (11.2) Part Number E14406-01 |
|
|
Mobi · ePub |
Move one or more objects of the same object type. The replace option allows you to overwrite.
parseMoveCommand = OMBMOVE "moveObjectType" "QUOTED_STRING" { ( OPERATOR | GROUP | ATTRIBUTE ) "QUOTED_STRING" } TO "QUOTED_STRING" { ( OPERATOR | GROUP | ATTRIBUTE ) "QUOTED_STRING" } [ USE REPLACE_MODE ] moveObjectType = ( "UNQUOTED_STRING" )
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.
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.
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.