Oracle® Warehouse Builder Scripting Reference 10g Release 1 (10.1) Part Number B12152-01 |
|
|
View PDF |
This chapter contains the following topics:
OMBDROP - Drop a component.
Should be in the parent context of the component to drop.
dropCommand = OMBDROP "fco_type" "fco_name";
dropCommand
Specify the component to drop.
fco_type
The type of the component.
fco_name
The physical name of the component in single quotes.
This is an example of dropping a table:
OMBDROP TABLE 'T1'
OMBCREATE, OMBALTER
OMBDROP ADVANCED_QUEUE - Delete the Advanced Queue.
Should be in the context of an Oracle Module.
dropAQCommand = OMBDROP ADVANCED_QUEUE "QUOTED_STRING";
dropAQCommand
Drops the Advanced Queue with the given name.
OMBDROP ADVANCED_QUEUE 'SOME_ADVANCED_QUEUE' This will delete the "SOME_ADVANCED_QUEUE" Advanced Queue.
OMBDROP, OMBCREATE ADVANCED_QUEUE, OMBALTER ADVANCED_QUEUE, OMBRETRIEVE ADVANCED_QUEUE
OMBDROP COLLECTION - Drop the collection object from this project.
Should be in the context of a project, before dropping a collection.
dropCollectionCommand = OMBDROP ( COLLECTION "QUOTED_STRING" );
dropCollectionCommand
Drop a collection of objects.
OMBDROP COLLECTION 'PURCHASING_WAREHOUSE'
OMBDROP, OMBALTER COLLECTION, OMBCREATE COLLECTION
OMBDROP CONNECTOR - Delete a connector.
Should be in the context of the connector's owning location.
dropConnectorCommand = OMBDROP ( CONNECTOR "QUOTED_STRING" );
dropConnectorCommand
Drops the named connector from the repository.
OMBDROP CONNECTOR 'A_CONNECTOR' This will delete the "A_CONNECTOR" connector.
OMBDROP, OMBCREATE CONNECTOR, OMBALTER CONNECTOR
OMBDROP CUBE_TABLE - This command drops a cube.
Should be in Oracle Module context.
OMBDropCube = OMBDROP CUBE_TABLE "cube_drop";cube_drop = "name";name = ( "QUOTED_STRING" );
OMBDropCube
OMBDROP CUBE_TABLE "cube_drop"
cube_drop
The name of the cube_table to be dropped.
name
The name has to be a quoted string or an integer, or a decimal number.
OMBDROP CUBE_TABLE 'CUBE1'
OMBCREATE CUBE_TABLE, OMBALTER CUBE_TABLE, OMBRETRIEVE CUBE_TABLE
OMBDROP DEPLOYMENT_ACTION_PLAN - Remove an existing deployment action plan.
There must be a current working project.
DropActionPlanCommand = ( OMBDROP ( DEPLOYMENT_ACTION_PLAN ) "QUOTED_STRING" );
DropActionPlanCommand
Remove an existing deployment action plan.
OMBDROP DEPLOYMENT_ACTION_PLAN 'MY_PLAN'
OMBCREATE DEPLOYMENT_ACTION_PLAN, OMBDEPLOY
OMBDROP EXTERNAL_TABLE - Delete the external table.
Should be in the context of an Oracle module.
dropExternalTableCommand = OMBDROP EXTERNAL_TABLE "QUOTED_STRING";
dropExternalTableCommand
Drop an external table from the repository.
QUOTED_STRING
The name of the external table to drop.
OMBDROP EXTERNAL_TABLE 'SRC_TABLE' This will delete the external table "SRC_TABLE".
OMBDROP, OMBCREATE EXTERNAL_TABLE, OMBALTER EXTERNAL_TABLE
OMBDROP FLAT_FILE - Delete a flat file.
Should be in the context of a flat file module.
dropFlatFileCommand = OMBDROP FLAT_FILE "QUOTED_STRING";
dropFlatFileCommand
Drop a flat file.
QUOTED_STRING
The name of the flat file to drop.
OMBDROP FLAT_FILE 'SRC_FILE' This will delete the flat file "SRC_FILE".
OMBDROP, OMBCREATE FLAT_FILE, OMBALTER FLAT_FILE
OMBDROP FLAT_FILE_MODULE - Delete a flat file module.
Should be in the context of a project.
dropFlatFileModuleCommand = OMBDROP ( FLAT_FILE_MODULE "QUOTED_STRING" );
dropFlatFileModuleCommand
Drop a flat file module.
QUOTED_STRING
The name of the flat file module to drop.
OMBDROP FLAT_FILE_MODULE 'src_module' This will delete the "src_module" flat file module.
OMBDROP, OMBCREATE FLAT_FILE_MODULE, OMBALTER FLAT_FILE_MODULE
OMBDROP FUNCTION - Delete the Function.
Should be in the context of a Oracle Module or Package or Transformation Module.
dropFunctionCommand = OMBDROP ( FUNCTION "QUOTED_STRING" );
dropFunctionCommand
Remove an existing Function.
QUOTED_STRING
Name of the existing Function in quotes.
OMBDROP FUNCTION 'func' This will delete the "func" Function. If Packaged Function is overloaded, first find the Signature by using OMBLIST command, and then use OMBALTER command using appropriate signature. Example, if OMBLIST FUNCTIONS gives following two signatures, FUNC_1 (NUMBER) RETURN NUMBER FUNC_1 (VARCHAR2, NUMBER) RETURN NUMBER The OMBDROP syntax to drop the first one will be as follows OMBDROP FUNCTION 'FUNC_1 \(NUMBER\) RETURN NUMBER'
OMBDROP, OMBCREATE FUNCTION, OMBALTER FUNCTION
OMBDROP GATEWAY_MODULE - Drop a gateway module.
Should be in the context of project.
dropGatewayModuleCommand = OMBDROP ( GATEWAY_MODULE "QUOTED_STRING" );
dropGatewayModuleCommand
Specify the gateway module to be dropped.
The following example drops a gateway module named IFMX:
OMBDROP GATEWAY_MODULE 'IFMX'
OMBDROP, OMBCREATE GATEWAY_MODULE, OMBALTER GATEWAY_MODULE
OMBDROP LOCATION - Delete the location.
Should be in the context of a project.
dropLocationCommand = OMBDROP ( LOCATION "QUOTED_STRING" );
dropLocationCommand
Drop a location from the design repository.
OMBDROP LOCATION 'OLD_LOCATION' This will delete the location "OLD_LOCATION".
OMBDROP, OMBCREATE LOCATION, OMBALTER LOCATION
OMBDROP MAPPING - Drop an existing mapping.
The current context of scripting must be an Oracle
dropMappingCommand = OMBDROP MAPPING "mappingName";mappingName = "QUOTED_STRING";
dropMappingCommand
Drop an existing mapping.
mappingName
Name of the mapping.
OMBDROP MAPPING 'MAP1'
OWBDROP, OMBCREATE MAPPING, OMBALTER MAPPING, OMBRETRIEVE MAPPING
OMBDROP MATERIALIZED_VIEW - To drop a materialized view.
In the context of an Oracle Module.
dropMaterializedViewCommand = OMBDROP MATERIALIZED_VIEW "QUOTED_STRING";
dropMaterializedViewCommand
This clause drops a MaterializedView.
OMBDROP MATERIALIZED_VIEW 'NEW_MATERIALIZED_VIEW'.
OMBRETRIEVE MATERIALIZED_VIEW, OMBCREATE MATERIALIZED_VIEW, OMBALTER MATERIALIZED_VIEW
OMBDROP OBJECT_TYPE - Delete the Object Type.
Should be in the context of an Oracle Module.
dropObjectTypeCommand = OMBDROP OBJECT_TYPE "QUOTED_STRING";
dropObjectTypeCommand
Drops the Object Type with given name.
OMBDROP OBJECT_TYPE 'SOME_OBJECT_TYPE' This will delete the "SOME_OBJECT_TYPE" Object Type.
OMBDROP, OMBCREATE OBJECT_TYPE, OMBALTER OBJECT_TYPE
OMBDROP ORACLE_MODULE - Delete the Oracle module.
Should be in the context of project.
dropOracleModuleCommand = OMBDROP ( ORACLE_MODULE "QUOTED_STRING" );
dropOracleModuleCommand
Remove an existing Oracle module.
QUOTED_STRING
Name of the existing Oracle module in quotes.
OMBDROP ORACLE_MODULE 'src_module' This will delete the "src_module" Oracle module.
OMBDROP, OMBCREATE ORACLE_MODULE, OMBALTER ORACLE_MODULE
OMBDROP PACKAGE - Delete the Package.
Should be in the context of a Oracle Module or Transformation Module.
dropPackageCommand = OMBDROP ( PACKAGE "QUOTED_STRING" );
dropPackageCommand
Remove an existing Package.
QUOTED_STRING
Name of the existing Package in quotes.
OMBDROP PACKAGE 'package_1' This will delete the "package_1" Package.
OMBDROP, OMBCREATE PACKAGE, OMBALTER PACKAGE
OMBDROP PROCEDURE - Delete the Procedure.
Should be in the context of a Oracle Module or Package or Transformation Module.
dropProcedureCommand = OMBDROP ( PROCEDURE "QUOTED_STRING" );
dropProcedureCommand
Remove an existing Procedure.
QUOTED_STRING
Name of the existing Procedure in quotes.
OMBDROP PROCEDURE 'proc' This will delete the "proc" Procedure. If Packaged Function is overloaded, first find the Signature by using OMBLIST command, and then use OMBALTER command using appropriate signature. Example, if OMBLIST PROCEDURES gives following two signatures, PROC_1 (NUMBER) PROC_1 (VARCHAR2, NUMBER) The OMBDROP syntax to drop the first one will be as follows OMBDROP PROCEDURE 'PROC_1 \(NUMBER\)'
OMBDROP, OMBCREATE PROCEDURE, OMBALTER PROCEDURE
OMBDROP PROCESS_FLOW - Delete the Process Flow.
Should be in the context of a Process Flow Package.
dropProcessFlowCommand = OMBDROP ( PROCESS_FLOW "QUOTED_STRING" );
dropProcessFlowCommand
Delete a process flow.
OMBDROP PROCESS_FLOW 'process_flow' This will delete the "process_flow" Process Flow.
OMBDROP, OMBCREATE PROCESS_FLOW, OMBALTER PROCESS_FLOW
OMBDROP PROCESS_FLOW_MODULE - Delete the Process Flow Module.
Should be in the context of a project.
dropProcessFlowModuleCommand = OMBDROP ( PROCESS_FLOW_MODULE "QUOTED_STRING" );
dropProcessFlowModuleCommand
Drop an existing process flow module.
OMBDROP PROCESS_FLOW_MODULE 'process_module' This will delete the "process_module" Process Flow Module.
OMBDROP, OMBCREATE PROCESS_FLOW_MODULE, OMBALTER PROCESS_FLOW_MODULE
OMBDROP PROCESS_FLOW_PACKAGE - Delete the Process Flow Package.
Should be in the context of a Process Flow Module.
dropProcessFlowPackageCommand = OMBDROP ( PROCESS_FLOW_PACKAGE "QUOTED_STRING" );
dropProcessFlowPackageCommand
Delete a process flow package.
OMBDROP PROCESS_FLOW_PACKAGE 'process_package' This will delete the "process_package" Process Flow Package.
OMBDROP, OMBCREATE PROCESS_FLOW_PACKAGE, OMBALTER PROCESS_FLOW_PACKAGE
OMBDROP PROJECT - Delete the project.
Should be in the top level context.
dropProjectCommand = OMBDROP ( PROJECT "QUOTED_STRING" );
dropProjectCommand
Remove an existing project.
QUOTED_STRING
Name of the existing project in quotes.
OMBDROP PROJECT 'New Project' This will delete the "New Project" project.
OMBDROP, OMBCREATE PROJECT, OMBALTER PROJECT
OMBDROP RUNTIME_REPOSITORY_CONNECTION - Delete the runtime repository connection.
Should be in the context of a project.
dropRuntimeRepositoryCommand = OMBDROP ( RUNTIME_REPOSITORY_CONNECTION "QUOTED_STRING" );
dropRuntimeRepositoryCommand
Drop the runtime repository connection from the repository.
OMBDROP RUNTIME_REPOSITORY_CONNECTION 'MY_CONNECTION' This will delete the "MY_CONNECTION" runtime repository connection.
OMBDROP, OMBCREATE RUNTIME_REPOSITORY_CONNECTION, OMBALTER RUNTIME_REPOSITORY_CONNECTION
OMBDROP SAP_MODULE - Remove an existing SAP module.
You must open a project to drop a SAP module.
dropSAPModuleCommand = OMBDROP ( SAP_MODULE "QUOTED_STRING" );
dropSAPModuleCommand
Remove an existing SAP module.
OMBDROP SAP_MODULE 'src_module' This will delete the "src_module" SAP module.
OMBDROP
OMBDROP SEQUENCE - To drop a sequence.
In the context of an Oracle Module.
dropSequenceCommand = OMBDROP SEQUENCE "QUOTED_STRING";
dropSequenceCommand
This clause drops a Sequence.
OMBDROP SEQUENCE 'new_sequence'.
OMBRETRIEVE SEQUENCE, OMBCREATE SEQUENCE, OMBALTER SEQUENCE
OMBDROP SNAPSHOT - A snapshot can be dropped.
The snapshot to be dropped should already exist. This command can be executed for any snapshot regardless of current context.
parseDropCommand = OMBDROP ( SNAPSHOT "QUOTED_STRING" );
parseDropCommand
To drop a snapshot.
QUOTED_STRING
Name of snapshot to be dropped.
OMBDROP SNAPSHOT 'S1'
OMBCREATE SNAPSHOT, OMBALTER SNAPSHOT, OMBRESTORE SNAPSHOT, OMBCOMPARE SNAPSHOT, OMBLIST SNAPSHOT, OMBRETRIEVE SNAPSHOT
OMBDROP TABLE - To drop a table.
In the context of an Oracle Module.
dropTableCommand = OMBDROP TABLE "QUOTED_STRING";
dropTableCommand
This clause drops a table.
OMBDROP TABLE 'old_table'.
OMBRETRIEVE TABLE, OMBCREATE TABLE, OMBALTER TABLE
OMBDROP VIEW - To drop a view.
In the context of an Oracle Module.
dropViewCommand = OMBDROP VIEW "QUOTED_STRING";
dropViewCommand
This clause drops a View.
OMBDROP VIEW 'NEW_VIEW'.
OMBRETRIEVE VIEW, OMBCREATE VIEW, OMBALTER VIEW