| Oracle® Warehouse Builder API and Scripting Reference 10g Release 2 (10.2) Part Number B28225-01 |
|
|
View PDF |
| Oracle® Warehouse Builder API and Scripting Reference 10g Release 2 (10.2) Part Number B28225-01 |
|
|
View PDF |
This chapter lists commands associated with OMBDROP in alphabetical order.
Purpose
Drop a component.
Prerequisites
Should be in the parent context of the component to drop.
Syntax
dropCommand = OMBDROP "fco_type" "fco_name"
Keywords And Parameters
dropCommand
Specify the component to drop.
fco_type
The type of the component.
fco_name
The physical name of the component in single quotes.
Examples
This is an example of dropping a table:
OMBDROP TABLE 'T1'
See Also
OMBCREATE, OMBALTER
Purpose
To drop an activity template folder.
Prerequisites
Should be in the context of a Activity Template folder.
Syntax
dropActivityTemplate = OMBDROP ACTIVITY_TEMPLATE "QUOTED_STRING"
Examples
OMBDROP ACTIVITY_TEMPLATE 'TEMPLATE1'
See Also
OMBDROP, OMBCREATE ACTIVITY_TEMPLATE, OMBALTER ACTIVITY_TEMPLATE
Purpose
To drop an activity template folder.
Prerequisites
Should be in the context of a Project.
Syntax
dropActivityTemplateFolder = OMBDROP ACTIVITY_TEMPLATE_FOLDER
"QUOTED_STRING"
Examples
OMBDROP ACTIVITY_TEMPLATE_FOLDER 'FOLDER1'
See Also
OMBDROP, OMBCREATE ACTIVITY_TEMPLATE_FOLDER, OMBALTER ACTIVITY_TEMPLATE_FOLDER
Purpose
Delete the Advanced Queue.
Prerequisites
Should be in the context of an Oracle Module.
Syntax
dropAQCommand = OMBDROP ADVANCED_QUEUE "QUOTED_STRING"
Keywords And Parameters
dropAQCommand
Drops the Advanced Queue with the given name.
Examples
OMBDROP ADVANCED_QUEUE 'SOME_ADVANCED_QUEUE'
This will delete the "SOME_ADVANCED_QUEUE" Advanced Queue.
See Also
OMBDROP, OMBCREATE ADVANCED_QUEUE, OMBALTER ADVANCED_QUEUE, OMBRETRIEVE ADVANCED_QUEUE
Purpose
To drop an Alternative Sort Order.
Prerequisites
Should be in the context of a Business Definition Module or use the full
path.
Syntax
dropAlternativeSortOrderCommand = OMBDROP ALTERNATIVE_SORT_ORDER
"QUOTED_STRING"
Keywords And Parameters
dropAlternativeSortOrderCommand
To drop an Alternative Sort Order.
Examples
OMBDROP ALTERNATIVE_SORT_ORDER 'customer_item'.
See Also
OMBRETRIEVE ALTERNATIVE_SORT_ORDER, OMBCREATE ALTERNATIVE_SORT_ORDER, OMBALTER ALTERNATIVE_SORT_ORDER
Purpose
To drop a profile action plan.
Prerequisites
An action plan for profiling must already exist.
Syntax
DropActionPlanCommand = ( OMBDROP ( ( DEPLOYMENT_ACTION_PLAN |
ANALYZE_ACTION_PLAN | CORRECTION_SCHEMA_ACTION_PLAN |
CORRECTION_MAPS_ACTION_PLAN ) ) "QUOTED_STRING" )
Keywords And Parameters
DropActionPlanCommand
Drop profile action plan
QUOTED_STRING
Name of profile action plan.
Examples
OMBDROP ANALYZE_ACTION_PLAN 'ANALYZE_PLAN'
alterAnalyzeActionPlanPreTag = An action plan for profiling must already
exist.
See Also
OMBCREATE ANALYZE_ACTION_PLAN, OMBPROFILE
Purpose
To drop a Business Area.
Prerequisites
Should be in the context of a Business Definition Module or use the full
path.
Syntax
dropBusinessAreaCommand = OMBDROP BUSINESS_AREA "QUOTED_STRING"
Keywords And Parameters
dropBusinessAreaCommand
To drop a Business Area.
Examples
OMBDROP BUSINESS_AREA 'sales'.
See Also
OMBRETRIEVE BUSINESS_AREA, OMBCREATE BUSINESS_AREA, OMBALTER BUSINESS_AREA
Purpose
Delete the business definition module.
Prerequisites
Should be in the context of project.
Syntax
dropEULModuleCommand = OMBDROP ( BUSINESS_DEFINITION_MODULE
"QUOTED_STRING" )
Keywords And Parameters
dropEULModuleCommand
Remove an existing business definition module.
QUOTED_STRING
Name of the existing business definition module in quotes.
Examples
OMBDROP BUSINESS_DEFINITION_MODULE 'src_module'
This will delete the "src_module" business definition module.
See Also
OMBDROP, OMBCREATE BUSINESS_DEFINITION_MODULE, OMBALTER BUSINESS_DEFINITION_MODULE
Purpose
Delete the presentation module.
Prerequisites
Should be in the context of project.
Syntax
dropReportModuleCommand = OMBDROP ( BUSINESS_PRESENTATION_MODULE
"QUOTED_STRING" )
Keywords And Parameters
dropReportModuleCommand
Remove an existing presentation module.
QUOTED_STRING
Name of the existing presentation module in quotes.
Examples
OMBDROP BUSINESS_PRESENTATION_MODULE 'salesrep_module'
This will delete the "salesrep_module" presentation module.
See Also
OMBDROP, OMBCREATE BUSINESS_PRESENTATION_MODULE, OMBALTER BUSINESS_PRESENTATION_MODULE
Purpose
To drop a calendar.
Prerequisites
Should be in the context of a Calendar Folder.
Syntax
parseDropCalendarCommand = OMBDROP CALENDAR "QUOTED_STRING"
Examples
OMBDROP CALENDAR 'CAL1'
See Also
OMBDROP, OMBCREATE CALENDAR, OMBALTER CALENDAR
Purpose
To drop a calendar module.
Prerequisites
Should be in the context of a Project.
Syntax
parseDropCalendarModuleCommand = OMBDROP CALENDAR_MODULE "QUOTED_STRING"
Examples
OMBDROP CALENDAR_MODULE 'CAL_MOD'
See Also
OMBDROP, OMBCREATE CALENDAR_MODULE, OMBALTER CALENDAR_MODULE
Purpose
This command is used to drop a change data capture.
Prerequisites
This command can only be executed in the context of a change data capture
and operates only on already existing change data capture.
Syntax
dropChangeSetCommand = OMBDROP ( CHANGE_DATA_CAPTURE "QUOTED_STRING" )
Examples
OMBDROP CHANGE_DATA_CAPTURE 'EMPLOYEE_CHANGES'
This deletes the change data capture.
See Also
OMBRETRIEVE CHANGE_DATA_CAPTURE, OMBCREATE CHANGE_DATA_CAPTURE, OMBALTER CHANGE_DATA_CAPTURE
Purpose
Delete the CMI definition.
Prerequisites
Should be in the root context.
Syntax
dropMIVDefinitionCommand = OMBDROP ( CMI_DEFINITION "QUOTED_STRING" )
Keywords And Parameters
dropMIVDefinitionCommand
Remove an existing CMI definition.
QUOTED_STRING
Name of the existing CMI definition in quotes.
Examples
OMBDROP CMI_DEFINITION 'src_definition'
This will delete the "src_definition" CMI definition.
See Also
OMBDROP, OMBCREATE CMI_DEFINITION
Purpose
Delete the CMI module.
Prerequisites
Should be in the context of project.
Syntax
dropMIVModuleCommand = OMBDROP ( CMI_MODULE "QUOTED_STRING" )
Keywords And Parameters
dropMIVModuleCommand
Remove an existing CMI module.
QUOTED_STRING
Name of the existing CMI module in quotes.
Examples
OMBDROP CMI_MODULE 'src_module'
This will delete the "src_module" CMI module.
See Also
OMBDROP, OMBCREATE CMI_MODULE, OMBALTER CMI_MODULE
Purpose
Drop the collection object from this project.
Prerequisites
Should be in the context of a project, before dropping a collection.
Syntax
dropCollectionCommand = OMBDROP ( COLLECTION "QUOTED_STRING" )
Keywords And Parameters
dropCollectionCommand
Drop a collection of objects.
Examples
OMBDROP COLLECTION 'PURCHASING_WAREHOUSE'
See Also
OMBDROP, OMBALTER COLLECTION, OMBCREATE COLLECTION
Purpose
Delete the Configuration.
Prerequisites
Should be in the context of a project.
Syntax
dropConfigurationCommand = OMBDROP ( CONFIGURATION "QUOTED_STRING" )
Keywords And Parameters
dropConfigurationCommand
Remove an existing Configuration.
Examples
OMBDROP CONFIGURATION 'QA_CONFIGURATION'
This will delete the "QA_CONFIGURATION" Configuration.
See Also
OMBDROP, OMBALTER CONFIGURATION, OMBCREATE CONFIGURATION
Purpose
Delete a connector.
Prerequisites
Can be in any context; the name is a name of the connector's owning
location and a connector name separated by slash.
Syntax
dropConnectorCommand = OMBDROP ( CONNECTOR "QUOTED_STRING" )
Keywords And Parameters
dropConnectorCommand
Drops the named connector from the repository.
Examples
OMBDROP CONNECTOR 'A_LOCATION/A_CONNECTOR'
This will delete the "A_CONNECTOR" connector of "A_LOCATION".
See Also
OMBDROP, OMBCREATE CONNECTOR, OMBALTER CONNECTOR
Purpose
Delete the control center.
Prerequisites
Can be in any context.
Syntax
dropControlCenterCommand = OMBDROP ( CONTROL_CENTER "QUOTED_STRING" )
Keywords And Parameters
dropControlCenterCommand
Drop the control center from the repository.
Examples
OMBDROP CONTROL_CENTER 'MY_CONNECTION'
This will delete the "MY_CONNECTION" control center.
See Also
OMBDROP, OMBCREATE CONTROL_CENTER, OMBALTER CONTROL_CENTER
Purpose
Drop an action plan for creating a correction map.
Prerequisites
In the context of a data profile.
Syntax
DropActionPlanCommand = ( OMBDROP ( ( DEPLOYMENT_ACTION_PLAN |
ANALYZE_ACTION_PLAN | CORRECTION_SCHEMA_ACTION_PLAN |
CORRECTION_MAPS_ACTION_PLAN ) ) "QUOTED_STRING" )
Keywords And Parameters
DropActionPlanCommand
Drop a correction map action plan.
QUOTED_STRING
Name of correction map action plan.
Examples
OMBDROP CORRECTION_MAPS_ACTION_PLAN 'CORRECT_INV_LOC_MAP'
See Also
OMBCREATE CORRECTION_MAPS_ACTION_PLAN, OMBPROFILE
Purpose
Drop an action plan for creating a correction schema
Prerequisites
In the context of a data profile.
Syntax
DropActionPlanCommand = ( OMBDROP ( ( DEPLOYMENT_ACTION_PLAN |
ANALYZE_ACTION_PLAN | CORRECTION_SCHEMA_ACTION_PLAN |
CORRECTION_MAPS_ACTION_PLAN ) ) "QUOTED_STRING" )
Keywords And Parameters
DropActionPlanCommand
drop correction schema action plan
QUOTED_STRING
Name of correction schema action plan.
Examples
OMBDROP CORRECTION_SCHEMA_ACTION_PLAN 'CORRECT_INV_LOC'
See Also
OMBCREATE CORRECTION_SCHEMA_ACTION_PLAN, OMBPROFILE
Purpose
This command drops a Cube.
Prerequisites
Should be in Oracle Module context.
Syntax
dropCubeCommand = OMBDROP CUBE "cubeName" cubeName = "QUOTED_STRING"
Examples
OMBDROP CUBE 'CUBE1'
See Also
OWBDROP, OMBCREATE CUBE, OMBALTER CUBE, OMBRETRIEVE CUBE
Purpose
Drop an existing data auditor.
Prerequisites
The current context of scripting must be an Oracle
Syntax
dropDataAuditorCommand = OMBDROP DATA_AUDITOR "dataAuditorName" dataAuditorName = "QUOTED_STRING"
Keywords And Parameters
dropDataAuditorCommand
Drop an existing data auditor.
dataAuditorName
Name of data auditor.
Examples
OMBDROP DATA_AUDITOR 'MAP1'
See Also
OWBDROP, OMBCREATE DATA_AUDITOR, OMBALTER DATA_AUDITOR, OMBRETRIEVE DATA_AUDITOR
Purpose
Delete the Data Profile.
Prerequisites
Should be in the context of project.
Syntax
dropDataProfileCommand = OMBDROP ( DATA_PROFILE "QUOTED_STRING" )
Keywords And Parameters
dropDataProfileCommand
Remove an existing Data Profile.
QUOTED_STRING
Name of the existing Data Profile in quotes.
Examples
OMBDROP DATA_PROFILE 'src_profile'
This will delete the "src_profile" Data Profile.
See Also
OMBDROP, OMBCREATE DATA_PROFILE, OMBALTER DATA_PROFILE
Purpose
Drop an existing data rule.
Prerequisites
The current context of scripting must be a data rule module.
Syntax
dropDataRuleCommand = OMBDROP DATA_RULE "QUOTED_STRING"
Keywords And Parameters
dropDataRuleCommand
This clause drops a data rule.
QUOTED_STRING
Data rule name.
Examples
OMBDROP DATA_RULE 'RULE1'
See Also
OMBRETRIEVE DATA_RULE, OMBCREATE DATA_RULE, OMBALTER DATA_RULE
Purpose
Delete the Deployment.
Prerequisites
Should be in the context of a Configuration.
Syntax
dropDeploymentCommand = OMBDROP ( DEPLOYMENT "QUOTED_STRING" )
Keywords And Parameters
dropDeploymentCommand
Remove an existing Deployment.
Examples
OMBDROP DEPLOYMENT 'QA_DEPLOYMENT'
This will delete the "QA_DEPLOYMENT" Deployment.
See Also
OMBDROP, OMBALTER DEPLOYMENT, OMBCREATE DEPLOYMENT
Purpose
Remove an existing deployment action plan.
Prerequisites
There must be a current working project.
Syntax
DropActionPlanCommand = ( OMBDROP ( ( DEPLOYMENT_ACTION_PLAN |
ANALYZE_ACTION_PLAN | CORRECTION_SCHEMA_ACTION_PLAN |
CORRECTION_MAPS_ACTION_PLAN ) ) "QUOTED_STRING" )
Keywords And Parameters
DropActionPlanCommand
Remove an existing deployment action plan.
Examples
OMBDROP DEPLOYMENT_ACTION_PLAN 'MY_PLAN'
See Also
OMBCREATE DEPLOYMENT_ACTION_PLAN, OMBDEPLOY
Purpose
This command drops a dimension.
Prerequisites
Should be in Oracle Module context.
Syntax
dropDimensionCommand = OMBDROP DIMENSION "dimensionName" dimensionName = "QUOTED_STRING"
Examples
OMBDROP DIMENSION 'PRODUCTS'
See Also
OWBDROP, OMBCREATE DIMENSION, OMBALTER DIMENSION, OMBRETRIEVE DIMENSION
Purpose
To drop a Drill Path.
Prerequisites
Should be in the context of a Business Definition Module or use the full
path.
Syntax
dropDrillPathCommand = OMBDROP DRILL_PATH "QUOTED_STRING"
Keywords And Parameters
dropDrillPathCommand
To drop a Drill Path.
Examples
OMBDROP DRILL_PATH 'product_rollup'.
See Also
OMBRETRIEVE DRILL_PATH, OMBCREATE DRILL_PATH, OMBALTER DRILL_PATH
Purpose
To drop a Drill to Detail.
Prerequisites
Should be in the context of a Business Definition Module or use the full
path.
Syntax
dropDrillToDetailCommand = OMBDROP DRILL_TO_DETAIL "QUOTED_STRING"
Keywords And Parameters
dropDrillToDetailCommand
To drop a Drill to Detail.
Examples
OMBDROP DRILL_TO_DETAIL 'customer_item'.
See Also
OMBRETRIEVE DRILL_TO_DETAIL, OMBCREATE DRILL_TO_DETAIL, OMBALTER DRILL_TO_DETAIL
Purpose
To drop an expert.
Prerequisites
In the context of an expert module.
Syntax
dropExpertCommand = OMBDROP EXPERT "QUOTED_STRING"
Keywords And Parameters
dropExpertCommand
Drop the specified expert.
Examples
This command will drop the expert EXP1:
OMBDROP EXPERT 'EXP1'
See Also
OMBDROP, OMBCREATE EXPERT, OMBALTER EXPERT, OMBRETRIEVE EXPERT
Purpose
To drop an expert module.
Prerequisites
In the context of a project.
Syntax
dropExpertModuleCommand = OMBDROP ( EXPERT_MODULE "QUOTED_STRING" )
Keywords And Parameters
dropExpertModuleCommand
Delete an expert module.
Examples
This command will drop the expert module EM1:
OMBDROP EXPERT_MODULE 'EM1'
See Also
OMBDROP, OMBCREATE EXPERT_MODULE, OMBALTER EXPERT_MODULE
Purpose
Delete the external table.
Prerequisites
Should be in the context of an Oracle module.
Syntax
dropExternalTableCommand = OMBDROP EXTERNAL_TABLE "QUOTED_STRING"
Keywords And Parameters
dropExternalTableCommand
Drop an external table from the repository.
QUOTED_STRING
The name of the external table to drop.
Examples
OMBDROP EXTERNAL_TABLE 'SRC_TABLE'
This will delete the external table "SRC_TABLE".
See Also
OMBDROP, OMBCREATE EXTERNAL_TABLE, OMBALTER EXTERNAL_TABLE, OMBRETRIEVE EXTERNAL_TABLE
Purpose
Delete a flat file.
Prerequisites
Should be in the context of a flat file module.
Syntax
dropFlatFileCommand = OMBDROP FLAT_FILE "QUOTED_STRING"
Keywords And Parameters
dropFlatFileCommand
Drop a flat file.
QUOTED_STRING
The name of the flat file to drop.
Examples
OMBDROP FLAT_FILE 'SRC_FILE'
This will delete the flat file "SRC_FILE".
See Also
OMBDROP, OMBCREATE FLAT_FILE, OMBALTER FLAT_FILE
Purpose
Delete a flat file module.
Prerequisites
Should be in the context of a project.
Syntax
dropFlatFileModuleCommand = OMBDROP ( FLAT_FILE_MODULE "QUOTED_STRING" )
Keywords And Parameters
dropFlatFileModuleCommand
Drop a flat file module.
QUOTED_STRING
The name of the flat file module to drop.
Examples
OMBDROP FLAT_FILE_MODULE 'src_module'
This will delete the "src_module" flat file module.
See Also
OMBDROP, OMBCREATE FLAT_FILE_MODULE, OMBALTER FLAT_FILE_MODULE
Purpose
Delete the Function.
Prerequisites
Should be in the context of a Oracle Module or Package or Transformation
Module.
A Transformation Module may be WB_CUSTOM_TRANS for Public Transformations.
WB_CUSTOM_TRANS may by modified by an administrator.
WB_CUSTOM_TRANS is not dependent on any project.
Syntax
dropFunctionCommand = OMBDROP ( FUNCTION "QUOTED_STRING" )
Keywords And Parameters
dropFunctionCommand
Remove an existing Function.
QUOTED_STRING
Name of the existing Function in quotes.
Examples
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'
See Also
OMBDROP, OMBCREATE FUNCTION, OMBALTER FUNCTION
Purpose
Delete the Gateway module.
Prerequisites
Should be in the context of project.
Syntax
dropGatewayModuleCommand = OMBDROP ( GATEWAY_MODULE "QUOTED_STRING" )
Keywords And Parameters
dropGatewayModuleCommand
Remove an existing Gateway module.
QUOTED_STRING
Name of the existing Gateway m odule in quotes.
Examples
OMBDROP GATEWAY_MODULE 'db2_module'
This will delete the "db2_module" Gateway module.
See Also
OMBDROP, OMBCREATE GATEWAY_MODULE, OMBALTER GATEWAY_MODULE
Purpose
To remove an iconset from the repository.
Prerequisites
Any context.
Syntax
dropIconSetCommand = OMBDROP ICONSET "QUOTED_STRING"
Keywords And Parameters
dropIconSetCommand
This command removes an iconset from the repository.
QUOTED_STRING
The name of the iconset to be removed.
Examples
OMBDROP ICONSET 'ICON1'
See Also
OMBCREATE ICONSET, OMBALTER ICONSET
Purpose
To drop a transient import action plan.
Prerequisites
In the context of a project
Syntax
dropImportActionPlanCommand = ( OMBDROP ( IMPORT_ACTION_PLAN )
"QUOTED_STRING" )
Keywords And Parameters
dropImportActionPlanCommand
This command is for dropping an import action plan.
QUOTED_STRING
The name of the import action plan to be dropped.
Examples
OMBDROP IMPORT_ACTION_PLAN 'PLAN1'
This command will erase the transient import action plan PLAN1 from memory.
See Also
OMBCREATE IMPORT_ACTION_PLAN, OMBIMPORT
Purpose
To drop an Item Folder.
Prerequisites
Should be in the context of a Business Definition Module or use the full
path.
Syntax
dropItemFolderCommand = OMBDROP ITEM_FOLDER "QUOTED_STRING"
Keywords And Parameters
dropItemFolderCommand
To drop an Item Folder.
Examples
OMBDROP ITEM_FOLDER 'customer'.
See Also
OMBRETRIEVE ITEM_FOLDER, OMBCREATE ITEM_FOLDER, OMBALTER ITEM_FOLDER
Purpose
To drop a List Of Values.
Prerequisites
Should be in the context of a Business Definition Module or use the full
path.
Syntax
dropListOfValuesCommand = OMBDROP LIST_OF_VALUES "QUOTED_STRING"
Keywords And Parameters
dropListOfValuesCommand
To drop a List Of Values.
Examples
OMBDROP LIST_OF_VALUES 'customer_item'.
See Also
OMBRETRIEVE LIST_OF_VALUES, OMBCREATE LIST_OF_VALUES, OMBALTER LIST_OF_VALUES
Purpose
Delete the location.
Prerequisites
Can be in any context.
Syntax
dropLocationCommand = OMBDROP ( LOCATION "QUOTED_STRING" )
Keywords And Parameters
dropLocationCommand
Drop a location from the repository.
Examples
OMBDROP LOCATION 'OLD_LOCATION'
This will delete the location "OLD_LOCATION".
See Also
OMBDROP, OMBCREATE LOCATION, OMBALTER LOCATION
Purpose
Drop an existing mapping.
Prerequisites
The current context of scripting must be an Oracle
Syntax
dropMappingCommand = OMBDROP MAPPING "mappingName" mappingName = "QUOTED_STRING"
Keywords And Parameters
dropMappingCommand
Drop an existing mapping.
mappingName
Name of the mapping.
Examples
OMBDROP MAPPING 'MAP1'
See Also
OMBDROP, OMBCREATE MAPPING, OMBALTER MAPPING, OMBRETRIEVE MAPPING
Purpose
To drop a materialized view.
Prerequisites
In the context of an Oracle Module.
Syntax
dropMaterializedViewCommand = OMBDROP MATERIALIZED_VIEW "QUOTED_STRING"
Keywords And Parameters
dropMaterializedViewCommand
This clause drops a MaterializedView.
Examples
OMBDROP MATERIALIZED_VIEW 'NEW_MATERIALIZED_VIEW'.
See Also
OMBDROP, OMBCREATE MATERIALIZED_VIEW, OMBALTER MATERIALIZED_VIEW, OMBRETRIEVE MATERIALIZED_VIEW
Purpose
Remove an existing metadata loader action plan.
Prerequisites
Connection must be established to the repository.
Syntax
dropMDLActionPlanCommand = ( OMBDROP ( MDL_ACTION_PLAN ) "QUOTED_STRING" )
Keywords And Parameters
dropMDLActionPlanCommand
Remove an existing metadata loader action plan.
QUOTED_STRING
Enclose the name of the metadata loader action plan in single quotes.
Examples
OMBDROP MDL_ACTION_PLAN 'MY_PLAN'
See Also
OMBCREATE MDL_ACTION_PLAN, OMBALTER MDL_ACTION_PLAN, OMBRETRIEVE MDL_ACTION_PLAN, OMUEXPORT MDL_FILE
Purpose
Drop an existing mining model.
Prerequisites
The current context of scripting must be an Oracle Module.
Syntax
dropMiningModelCommand = OMBDROP MINING_MODEL "miningModelName" miningModelName = "QUOTED_STRING"
Examples
OMBDROP MINING_MODEL 'MODEL1'
See Also
OMBDROP, OMBCREATE MINING_MODEL, OMBALTER MINING_MODEL, OMBRETRIEVE MINING_MODEL
Purpose
Delete the Nested Table.
Prerequisites
Should be in the context of an Oracle Module.
Syntax
dropNestedTableCommand = OMBDROP NESTED_TABLE "QUOTED_STRING"
Examples
OMBDROP NESTED_TABLE 'SOME_NESTED_TABLE'
This will delete the "SOME_NESTED_TABLE" Nested Table.
See Also
OMBRETRIEVE NESTED_TABLE, OMBCREATE NESTED_TABLE, OMBALTER NESTED_TABLE
Purpose
Delete the Object Type.
Prerequisites
Should be in the context of an Oracle Module.
Syntax
dropObjectTypeCommand = OMBDROP OBJECT_TYPE "QUOTED_STRING"
Keywords And Parameters
dropObjectTypeCommand
Drops the Object Type with given name.
Examples
OMBDROP OBJECT_TYPE 'SOME_OBJECT_TYPE'
This will delete the "SOME_OBJECT_TYPE" Object Type.
See Also
OMBDROP, OMBCREATE OBJECT_TYPE, OMBALTER OBJECT_TYPE
Purpose
Delete the Oracle module.
Prerequisites
Should be in the context of project.
Syntax
dropOracleModuleCommand = OMBDROP ( ORACLE_MODULE "QUOTED_STRING" )
Keywords And Parameters
dropOracleModuleCommand
Remove an existing Oracle module.
QUOTED_STRING
Name of the existing Oracle module in quotes.
Examples
OMBDROP ORACLE_MODULE 'src_module'
This will delete the "src_module" Oracle module.
See Also
OMBDROP, OMBCREATE ORACLE_MODULE, OMBALTER ORACLE_MODULE
Purpose
Delete the Package.
Prerequisites
Should be in the context of a Oracle Module or Transformation Module.
A Transformation Module may be WB_CUSTOM_TRANS for Public Transformations.
WB_CUSTOM_TRANS may by modified by an administrator.
WB_CUSTOM_TRANS is not dependent on any project.
Syntax
dropPackageCommand = OMBDROP ( PACKAGE "QUOTED_STRING" )
Keywords And Parameters
dropPackageCommand
Remove an existing Package.
QUOTED_STRING
Name of the existing Package in quotes.
Examples
OMBDROP PACKAGE 'package_1'
This will delete the "package_1" Package.
See Also
OMBDROP, OMBCREATE PACKAGE, OMBALTER PACKAGE
Purpose
Delete the PLSQL Record Type.
Prerequisites
Should be in the context of a Package.
Syntax
dropPlSqlRecordTypeCommand = OMBDROP PLSQL_RECORD_TYPE "QUOTED_STRING"
Keywords And Parameters
dropPlSqlRecordTypeCommand
Drops the PLSQL Record Type with given name.
Examples
OMBDROP PLSQL_RECORD_TYPE 'SOME_PLSQL_RECORD_TYPE'
This will delete the "SOME_PLSQL_RECORD_TYPE" PLSQL Record Type.
See Also
OMBDROP, OMBCREATE PLSQL_RECORD_TYPE, OMBALTER PLSQL_RECORD_TYPE
Purpose
Delete the Ref-cursor Type.
Prerequisites
Should be in the context of a Package.
Syntax
dropPlSqlRefCursorTypeCommand = OMBDROP PLSQL_REF_CURSOR_TYPE
"QUOTED_STRING"
Keywords And Parameters
dropPlSqlRefCursorTypeCommand
Drops the Ref-cursor Type with given name.
Examples
OMBDROP PLSQL_REF_CURSOR_TYPE 'SOME_PLSQL_REF_CURSOR_TYPE'
This will delete the "SOME_PLSQL_REF_CURSOR_TYPE" Ref-cursor Type.
See Also
OMBDROP, OMBCREATE PLSQL_REF_CURSOR_TYPE, OMBALTER PLSQL_REF_CURSOR_TYPE
Purpose
Delete the Table Type.
Prerequisites
Should be in the context of a Package.
Syntax
dropPlSqlTableTypeCommand = OMBDROP PLSQL_TABLE_TYPE "QUOTED_STRING"
Keywords And Parameters
dropPlSqlTableTypeCommand
Drops the Table Type with given name.
Examples
OMBDROP PLSQL_TABLE_TYPE 'SOME_PLSQL_TABLE_TYPE'
This will delete the "SOME_PLSQL_TABLE_TYPE" Table Type.
See Also
OMBDROP, OMBCREATE PLSQL_TABLE_TYPE, OMBALTER PLSQL_TABLE_TYPE
Purpose
Drop an existing pluggable mapping.
Prerequisites
The current context of scripting must be a project or pluggable map folder.
Syntax
dropPluggableMappingCommand = OMBDROP PLUGGABLE_MAPPING "pluggableMapName" pluggableMapName = "QUOTED_STRING"
Keywords And Parameters
dropPluggableMappingCommand
Drop an existing pluggable map folder.
pluggableMapName
Name of the pluggable map.
Examples
OMBDROP PLUGGABLE_MAP 'PLUGGABLE_MAP1'
See Also
OMBDROP, OMBCREATE PLUGGABLE_MAPPING, OMBALTER PLUGGABLE_MAPPING, OMBRETRIEVE PLUGGABLE_MAPPING
Purpose
Drop an existing pluggable map folder.
Prerequisites
The current context of scripting must be a project.
Syntax
dropPluggableMappingFolderCommand = OMBDROP PLUGGABLE_MAPPING_FOLDER
"pluggableMapFolderName"
pluggableMapFolderName = "QUOTED_STRING"
Keywords And Parameters
dropPluggableMappingFolderCommand
Drop an existing pluggable map folder.
pluggableMapFolderName
Name of the pluggable map folder.
Examples
OMBDROP PLUGGABLE_MAP_FOLDER 'PLUGGABLE_MAP_FOLDER1'
See Also
OMBDROP
Purpose
To drop a presentation template.
Prerequisites
Should be in the context of a business presentation module or use the full
path.
Syntax
dropReportCommand = OMBDROP PRESENTATION_TEMPLATE "QUOTED_STRING"
Keywords And Parameters
dropReportCommand
To drop a presentation template.
Examples
OMBDROP PRESENTATION_TEMPLATE 'sales'.
See Also
OMBRETRIEVE PRESENTATION_TEMPLATE, OMBCREATE PRESENTATION_TEMPLATE, OMBALTER PRESENTATION_TEMPLATE
Purpose
Delete the Procedure.
Prerequisites
Should be in the context of a Oracle Module or Package or Transformation
Module.
A Transformation Module may be WB_CUSTOM_TRANS for Public Transformations.
WB_CUSTOM_TRANS may by modified by an administrator.
WB_CUSTOM_TRANS is not dependent on any project.
Syntax
dropProcedureCommand = OMBDROP ( PROCEDURE "QUOTED_STRING" )
Keywords And Parameters
dropProcedureCommand
Remove an existing Procedure.
QUOTED_STRING
Name of the existing Procedure in quotes.
Examples
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\)'
See Also
OMBDROP, OMBCREATE PROCEDURE, OMBALTER PROCEDURE
Purpose
Delete the Process Flow.
Prerequisites
Should be in the context of a Process Flow Package.
Syntax
dropProcessFlowCommand = OMBDROP ( PROCESS_FLOW "QUOTED_STRING" )
Keywords And Parameters
dropProcessFlowCommand
Delete a process flow.
Examples
OMBDROP PROCESS_FLOW 'process_flow'
This will delete the "process_flow" Process Flow.
See Also
OMBDROP, OMBCREATE PROCESS_FLOW, OMBALTER PROCESS_FLOW
Purpose
Delete the Process Flow Module.
Prerequisites
Should be in the context of a project.
Syntax
dropProcessFlowModuleCommand = OMBDROP ( PROCESS_FLOW_MODULE
"QUOTED_STRING" )
Keywords And Parameters
dropProcessFlowModuleCommand
Drop an existing process flow module.
Examples
OMBDROP PROCESS_FLOW_MODULE 'process_module'
This will delete the "process_module" Process Flow Module.
See Also
OMBDROP, OMBCREATE PROCESS_FLOW_MODULE, OMBALTER PROCESS_FLOW_MODULE
Purpose
Delete the Process Flow Package.
Prerequisites
Should be in the context of a Process Flow Module.
Syntax
dropProcessFlowPackageCommand = OMBDROP ( PROCESS_FLOW_PACKAGE
"QUOTED_STRING" )
Keywords And Parameters
dropProcessFlowPackageCommand
Delete a process flow package.
Examples
OMBDROP PROCESS_FLOW_PACKAGE 'process_package'
This will delete the "process_package" Process Flow Package.
See Also
OMBDROP, OMBCREATE PROCESS_FLOW_PACKAGE, OMBALTER PROCESS_FLOW_PACKAGE
Purpose
Delete the project.
Prerequisites
Should be in the top level context.
Syntax
dropProjectCommand = OMBDROP ( PROJECT "QUOTED_STRING" )
Keywords And Parameters
dropProjectCommand
Remove an existing project.
QUOTED_STRING
Name of the existing project in quotes.
Examples
OMBDROP PROJECT 'New Project'
This will delete the "New Project" project.
See Also
OMBDROP, OMBCREATE PROJECT, OMBALTER PROJECT
Purpose
Delete the Queue Propagation.
Prerequisites
Should be in the context of an Advanced Queue.
Syntax
dropQPCommand = OMBDROP QUEUE_PROPAGATION "QUOTED_STRING"
Keywords And Parameters
dropQPCommand
Drops the Queue Propagation with the given name.
Examples
OMBDROP QUEUE_PROPAGATION 'SOME_QUEUE_PROPAGATION'
This will delete the "SOME_QUEUE_PROPAGATION" Queue Propagation.
See Also
OMBDROP, OMBCREATE QUEUE_PROPAGATION, OMBALTER QUEUE_PROPAGATION, OMBRETRIEVE QUEUE_PROPAGATION
Purpose
Delete the Queue Table.
Prerequisites
Should be in the context of an Oracle Module.
Syntax
dropQTCommand = OMBDROP QUEUE_TABLE "QUOTED_STRING"
Keywords And Parameters
dropQTCommand
Drops the Queue Table with the given name.
Examples
OMBDROP QUEUE_TABLE 'SOME_QUEUE_TABLE'
This will delete the "SOME_QUEUE_TABLE" Queue Table.
See Also
OMBDROP, OMBCREATE QUEUE_TABLE, OMBALTER QUEUE_TABLE, OMBRETRIEVE QUEUE_TABLE
Purpose
Drop an existing Real Time mapping.
Prerequisites
The current context of scripting must be an Oracle
Syntax
dropRealTimeMappingCommand = OMBDROP REAL_TIME_MAPPING "mappingName" mappingName = "QUOTED_STRING"
Keywords And Parameters
mappingName
Name of the mapping.
Examples
OMBDROP REAL_TIME_MAPPING 'MAP1'
See Also
OMBDROP, OMBCREATE REAL_TIME_MAPPING, OMBALTER REAL_TIME_MAPPING, OMBRETRIEVE REAL_TIME_MAPPING
Purpose
To drop an I/O Function.
Prerequisites
Should be in the context of a Business Definition Module or use the full
path.
Syntax
dropRegisteredFunctionCommand = OMBDROP REGISTERED_FUNCTION
"QUOTED_STRING"
Keywords And Parameters
dropRegisteredFunctionCommand
To drop an I/O Function.
Examples
OMBDROP REGISTERED_FUNCTION 'sum'.
See Also
OMBRETRIEVE REGISTERED_FUNCTION, OMBCREATE REGISTERED_FUNCTION, OMBALTER REGISTERED_FUNCTION
Purpose
To drop a Warehouse Builder role.
Prerequisites
Must be connected to a OWB repository.
Syntax
parseDropRoleCommand = ( OMBDROP ROLE "QUOTED_STRING" )
Keywords And Parameters
parseDropRoleCommand
This clause drops a Warehouse Builder role.
Examples
OMBDROP ROLE 'DEVELOPMENT_ROLE'
will drop role 'DEVELOPMENT_ROLE'.
See Also
OMBCREATE ROLE, OMBALTER ROLE, OMBRETRIEVE ROLE, OMBLIST ROLES
Purpose
Remove an existing SAP module.
Prerequisites
You must open a project to drop a SAP module.
Syntax
dropSAPModuleCommand = OMBDROP ( SAP_MODULE "QUOTED_STRING" )
Keywords And Parameters
dropSAPModuleCommand
Remove an existing SAP module.
Examples
OMBDROP SAP_MODULE 'src_module'
This will delete the "src_module" SAP module.
See Also
OMBDROP
Purpose
To drop a sequence.
Prerequisites
In the context of an Oracle Module.
Syntax
dropSequenceCommand = OMBDROP SEQUENCE "QUOTED_STRING"
Keywords And Parameters
dropSequenceCommand
This clause drops a Sequence.
Examples
OMBDROP SEQUENCE 'new_sequence'.
See Also
OMBDROP, OMBCREATE SEQUENCE, OMBALTER SEQUENCE, OMBRETRIEVE SEQUENCE
Purpose
A snapshot can be dropped.
Prerequisites
The snapshot to be dropped should already exist. This command can be
executed for any snapshot regardless of current context.
Syntax
parseDropCommand = OMBDROP ( SNAPSHOT "QUOTED_STRING" )
Keywords And Parameters
parseDropCommand
To drop a snapshot.
QUOTED_STRING
Name of snapshot to be dropped.
Examples
OMBDROP SNAPSHOT 'S1'
See Also
OMBCREATE SNAPSHOT, OMBALTER SNAPSHOT, OMBRESTORE SNAPSHOT, OMBCOMPARE SNAPSHOT, OMBLIST SNAPSHOT, OMBRETRIEVE SNAPSHOT
Purpose
Delete the Streams Capture Process.
Prerequisites
Should be in the context of a Streams Queue.
Syntax
dropCaptureCommand = OMBDROP STREAMS_CAPTURE_PROCESS "QUOTED_STRING"
Keywords And Parameters
dropCaptureCommand
Drops the Streams Capture Process with the given name.
Examples
OMBDROP STREAMS_CAPTURE_PROCESS 'SOME_CAPTURE_PROCESS'
This will delete the "SOME_CAPTURE_PROCESS" Streams Capture Process.
See Also
OMBDROP, OMBCREATE STREAMS_CAPTURE_PROCESS, OMBALTER STREAMS_CAPTURE_PROCESS, OMBRETRIEVE STREAMS_CAPTURE_PROCESS
Purpose
Delete the Streams Queue.
Prerequisites
Should be in the context of an Oracle Module.
Syntax
dropANYQCommand = OMBDROP STREAMS_QUEUE "QUOTED_STRING"
Keywords And Parameters
dropANYQCommand
Drops the Streams Queue with the given name.
Examples
OMBDROP STREAMS_QUEUE 'SOME_STREAMS_QUEUE'
This will delete the "SOME_STREAMS_QUEUE" Streams Queue.
See Also
OMBDROP, OMBCREATE STREAMS_QUEUE, OMBALTER STREAMS_QUEUE, OMBRETRIEVE STREAMS_QUEUE
Purpose
To drop a table.
Prerequisites
In the context of an Oracle Module.
Syntax
dropTableCommand = OMBDROP TABLE "QUOTED_STRING"
Keywords And Parameters
dropTableCommand
This clause drops a table.
Examples
OMBDROP TABLE 'old_table'.
See Also
OMBDROP, OMBCREATE TABLE, OMBALTER TABLE, OMBRETRIEVE TABLE
Purpose
Delete the Table Function.
Prerequisites
Should be in the context of Oracle Module or Package.
Syntax
dropTableFunctionCommand = OMBDROP ( TABLE_FUNCTION "QUOTED_STRING" )
Keywords And Parameters
dropTableFunctionCommand
Drops a Table Function
Examples
OMBDROP TABLE_FUNCTION 'table_function'
This will delete the "table_function" Table Function.
See Also
OMBDROP, OMBCREATE TABLE_FUNCTION, OMBALTER TABLE_FUNCTION
Purpose
This command drops a time dimension.
Prerequisites
Should be in Oracle Module context.
Syntax
dropTimeDimensionCommand = OMBDROP TIME_DIMENSION "TimeDimensionName" TimeDimensionName = "QUOTED_STRING"
Keywords And Parameters
TimeDimensionName
The name of the time dimension.
Examples
OMBDROP TIME_DIMENSION 'YR2005'
See Also
OMBCREATE TIME_DIMENSION, OMBALTER TIME_DIMENSION, OMBRETRIEVE TIME_DIMENSION
Purpose
To drop a transportable module.
Prerequisites
In the context of a project.
Syntax
dropTMCommand = OMBDROP TRANSPORTABLE_MODULE "QUOTED_STRING"
Keywords And Parameters
dropTMCommand
This command is for dropping a transportable module.
QUOTED_STRING
The transportable module to be dropped.
Examples
OMBDROP TRANSPORTABLE_MODULE 'TM101'
This command will drop the transportable module TM101 and all its content.
See Also
OMBCREATE TRANSPORTABLE_MODULE
Purpose
Delete the Varying Array.
Prerequisites
Should be in the context of an Oracle Module.
Syntax
dropVaryingArrayCommand = OMBDROP VARYING_ARRAY "QUOTED_STRING"
Examples
OMBDROP VARYING_ARRAY 'SOME_VARRAY'
This will delete the "SOME_VARRAY" Varying Array.
See Also
OMBRETRIEVE VARYING_ARRAY, OMBCREATE VARYING_ARRAY, OMBALTER VARYING_ARRAY
Purpose
To drop a view.
Prerequisites
In the context of an Oracle Module.
Syntax
dropViewCommand = OMBDROP VIEW "QUOTED_STRING"
Keywords And Parameters
dropViewCommand
This clause drops a View.
Examples
OMBDROP VIEW 'NEW_VIEW'.
See Also
OMBDROP, OMBCREATE VIEW, OMBALTER VIEW, OMBRETRIEVE VIEW
|
 Copyright © 2000, 2006, Oracle. All rights reserved. Legal Notices |
|