This chapter lists commands associated with OMBDROP in alphabetical order.
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.
OMBCREATE, OMBALTER
To drop an activity template folder.
Should be in the context of a Project.
dropActivityTemplateFolder = OMBDROP ACTIVITY_TEMPLATE_FOLDER "QUOTED_STRING"
OMBDROP, OMBCREATE ACTIVITY_TEMPLATE_FOLDER, OMBALTER ACTIVITY_TEMPLATE_FOLDER
To drop an activity template folder.
Should be in the context of a Activity Template folder.
dropActivityTemplate = OMBDROP ACTIVITY_TEMPLATE "QUOTED_STRING"
OMBDROP, OMBCREATE ACTIVITY_TEMPLATE, OMBALTER ACTIVITY_TEMPLATE
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, OMBCREATE ADVANCED_QUEUE, OMBALTER ADVANCED_QUEUE, OMBRETRIEVE ADVANCED_QUEUE
To drop an Alternative Sort Order.
Should be in the context of a Business Definition Module or use the full
path.
dropAlternativeSortOrderCommand = OMBDROP ALTERNATIVE_SORT_ORDER "QUOTED_STRING"
dropAlternativeSortOrderCommand
To drop an Alternative Sort Order.
OMBRETRIEVE ALTERNATIVE_SORT_ORDER, OMBCREATE ALTERNATIVE_SORT_ORDER, OMBALTER ALTERNATIVE_SORT_ORDER
To drop a profile action plan.
An action plan for profiling must already exist.
DropActionPlanCommand = ( OMBDROP ( ( DEPLOYMENT_ACTION_PLAN | ANALYZE_ACTION_PLAN | CORRECTION_SCHEMA_ACTION_PLAN | CORRECTION_MAPS_ACTION_PLAN ) ) "QUOTED_STRING" )
DropActionPlanCommand
Drop profile action plan
QUOTED_STRING
Name of profile action plan.
OMBCREATE ANALYZE_ACTION_PLAN, OMBPROFILE
To drop a Business Area.
Should be in the context of a Business Definition Module or use the full
path.
dropBusinessAreaCommand = OMBDROP BUSINESS_AREA "QUOTED_STRING"
dropBusinessAreaCommand
To drop a Business Area.
OMBRETRIEVE BUSINESS_AREA, OMBCREATE BUSINESS_AREA, OMBALTER BUSINESS_AREA
Delete the business definition module.
Should be in the context of project.
dropEULModuleCommand = OMBDROP ( BUSINESS_DEFINITION_MODULE "QUOTED_STRING" )
dropEULModuleCommand
Remove an existing business definition module.
QUOTED_STRING
Name of the existing business definition module in quotes.
OMBDROP, OMBCREATE BUSINESS_DEFINITION_MODULE, OMBALTER BUSINESS_DEFINITION_MODULE
Delete the presentation module.
Should be in the context of project.
dropReportModuleCommand = OMBDROP ( BUSINESS_PRESENTATION_MODULE "QUOTED_STRING" )
dropReportModuleCommand
Remove an existing presentation module.
QUOTED_STRING
Name of the existing presentation module in quotes.
OMBDROP, OMBCREATE BUSINESS_PRESENTATION_MODULE, OMBALTER BUSINESS_PRESENTATION_MODULE
To drop a calendar.
Should be in the context of a Calendar Folder.
parseDropCalendarCommand = OMBDROP CALENDAR "QUOTED_STRING"
OMBDROP, OMBCREATE CALENDAR, OMBALTER CALENDAR
To drop a calendar module.
Should be in the context of a Project.
parseDropCalendarModuleCommand = OMBDROP CALENDAR_MODULE "QUOTED_STRING"
OMBDROP, OMBCREATE CALENDAR_MODULE, OMBALTER CALENDAR_MODULE
This command is used to drop a change data capture.
This command can only be executed in the context of a change data capture
and operates only on already existing change data capture.
dropChangeSetCommand = OMBDROP ( CHANGE_DATA_CAPTURE "QUOTED_STRING" )
OMBRETRIEVE CHANGE_DATA_CAPTURE, OMBCREATE CHANGE_DATA_CAPTURE, OMBALTER CHANGE_DATA_CAPTURE
Delete the CMI definition.
Should be in the root context.
dropMIVDefinitionCommand = OMBDROP ( CMI_DEFINITION "QUOTED_STRING" )
dropMIVDefinitionCommand
Remove an existing CMI definition.
QUOTED_STRING
Name of the existing CMI definition in quotes.
OMBDROP, OMBCREATE CMI_DEFINITION
Delete the CMI module.
Should be in the context of project.
dropMIVModuleCommand = OMBDROP ( CMI_MODULE "QUOTED_STRING" )
dropMIVModuleCommand
Remove an existing CMI module.
QUOTED_STRING
Name of the existing CMI module in quotes.
OMBDROP, OMBCREATE CMI_MODULE, OMBALTER CMI_MODULE
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, OMBALTER COLLECTION, OMBCREATE COLLECTION
Delete the Configuration.
Should be in the context of a project.
dropConfigurationCommand = OMBDROP ( CONFIGURATION "QUOTED_STRING" )
dropConfigurationCommand
Remove an existing Configuration.
OMBDROP, OMBALTER CONFIGURATION, OMBCREATE CONFIGURATION
Delete a connector.
Can be in any context; the name is a name of the connector's owning
location and a connector name separated by slash.
dropConnectorCommand = OMBDROP ( CONNECTOR "QUOTED_STRING" )
dropConnectorCommand
Drops the named connector from the repository.
OMBDROP, OMBCREATE CONNECTOR, OMBALTER CONNECTOR
Delete the control center.
Can be in any context.
dropControlCenterCommand = OMBDROP ( CONTROL_CENTER "QUOTED_STRING" )
dropControlCenterCommand
Drop the control center from the workspace.
OMBDROP, OMBCREATE CONTROL_CENTER, OMBALTER CONTROL_CENTER
Drop an action plan for creating a correction map.
In the context of a data profile.
DropActionPlanCommand = ( OMBDROP ( ( DEPLOYMENT_ACTION_PLAN | ANALYZE_ACTION_PLAN | CORRECTION_SCHEMA_ACTION_PLAN | CORRECTION_MAPS_ACTION_PLAN ) ) "QUOTED_STRING" )
DropActionPlanCommand
Drop a correction map action plan.
QUOTED_STRING
Name of correction map action plan.
OMBCREATE CORRECTION_MAPS_ACTION_PLAN, OMBPROFILE
Drop an action plan for creating a correction schema
In the context of a data profile.
DropActionPlanCommand = ( OMBDROP ( ( DEPLOYMENT_ACTION_PLAN | ANALYZE_ACTION_PLAN | CORRECTION_SCHEMA_ACTION_PLAN | CORRECTION_MAPS_ACTION_PLAN ) ) "QUOTED_STRING" )
DropActionPlanCommand
drop correction schema action plan
QUOTED_STRING
Name of correction schema action plan.
OMBCREATE CORRECTION_SCHEMA_ACTION_PLAN, OMBPROFILE
This command drops a Cube.
Should be in Oracle Module context.
dropCubeCommand = OMBDROP CUBE "cubeName" cubeName = "QUOTED_STRING"
OWBDROP, OMBCREATE CUBE, OMBALTER CUBE, OMBRETRIEVE CUBE
Drop an existing data auditor.
The current context of scripting must be an Oracle
dropDataAuditorCommand = OMBDROP DATA_AUDITOR "dataAuditorName" dataAuditorName = "QUOTED_STRING"
dropDataAuditorCommand
Drop an existing data auditor.
dataAuditorName
Name of data auditor.
OWBDROP, OMBCREATE DATA_AUDITOR, OMBALTER DATA_AUDITOR, OMBRETRIEVE DATA_AUDITOR
Delete the Data Profile.
Should be in the context of project.
dropDataProfileCommand = OMBDROP ( DATA_PROFILE "QUOTED_STRING" )
dropDataProfileCommand
Remove an existing Data Profile.
QUOTED_STRING
Name of the existing Data Profile in quotes.
OMBDROP, OMBCREATE DATA_PROFILE, OMBALTER DATA_PROFILE
Drop an existing data rule.
The current context of scripting must be a data rule module.
dropDataRuleCommand = OMBDROP DATA_RULE "QUOTED_STRING"
dropDataRuleCommand
This clause drops a data rule.
QUOTED_STRING
Data rule name.
OMBRETRIEVE DATA_RULE, OMBCREATE DATA_RULE, OMBALTER DATA_RULE
Remove an existing deployment action plan.
There must be a current working project.
DropActionPlanCommand = ( OMBDROP ( ( DEPLOYMENT_ACTION_PLAN | ANALYZE_ACTION_PLAN | CORRECTION_SCHEMA_ACTION_PLAN | CORRECTION_MAPS_ACTION_PLAN ) ) "QUOTED_STRING" )
DropActionPlanCommand
Remove an existing deployment action plan.
OMBCREATE DEPLOYMENT_ACTION_PLAN, OMBDEPLOY
Delete the Deployment.
Should be in the context of a Configuration.
dropDeploymentCommand = OMBDROP ( DEPLOYMENT "QUOTED_STRING" )
dropDeploymentCommand
Remove an existing Deployment.
OMBDROP, OMBALTER DEPLOYMENT, OMBCREATE DEPLOYMENT
This command drops a dimension.
Should be in Oracle Module context.
dropDimensionCommand = OMBDROP DIMENSION "dimensionName" dimensionName = "QUOTED_STRING"
OWBDROP, OMBCREATE DIMENSION, OMBALTER DIMENSION, OMBRETRIEVE DIMENSION
To drop a Drill Path.
Should be in the context of a Business Definition Module or use the full
path.
dropDrillPathCommand = OMBDROP DRILL_PATH "QUOTED_STRING"
dropDrillPathCommand
To drop a Drill Path.
OMBRETRIEVE DRILL_PATH, OMBCREATE DRILL_PATH, OMBALTER DRILL_PATH
To drop a Drill to Detail.
Should be in the context of a Business Definition Module or use the full
path.
dropDrillToDetailCommand = OMBDROP DRILL_TO_DETAIL "QUOTED_STRING"
dropDrillToDetailCommand
To drop a Drill to Detail.
OMBRETRIEVE DRILL_TO_DETAIL, OMBCREATE DRILL_TO_DETAIL, OMBALTER DRILL_TO_DETAIL
To drop an expert.
In the context of an expert module.
dropExpertCommand = OMBDROP EXPERT "QUOTED_STRING"
dropExpertCommand
Drop the specified expert.
OMBDROP, OMBCREATE EXPERT, OMBALTER EXPERT, OMBRETRIEVE EXPERT
To drop an expert module.
In the context of a project.
dropExpertModuleCommand = OMBDROP ( EXPERT_MODULE "QUOTED_STRING" )
dropExpertModuleCommand
Delete an expert module.
OMBDROP, OMBCREATE EXPERT_MODULE, OMBALTER EXPERT_MODULE
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, OMBCREATE EXTERNAL_TABLE, OMBALTER EXTERNAL_TABLE, OMBRETRIEVE EXTERNAL_TABLE
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, OMBCREATE FLAT_FILE, OMBALTER FLAT_FILE
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, OMBCREATE FLAT_FILE_MODULE, OMBALTER FLAT_FILE_MODULE
Delete the Function.
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.
dropFunctionCommand = OMBDROP ( FUNCTION "QUOTED_STRING" )
dropFunctionCommand
Remove an existing Function.
QUOTED_STRING
Name of the existing Function in quotes.
OMBDROP, OMBCREATE FUNCTION, OMBALTER FUNCTION
Delete the Gateway module.
Should be in the context of project.
dropGatewayModuleCommand = OMBDROP ( GATEWAY_MODULE "QUOTED_STRING" )
dropGatewayModuleCommand
Remove an existing Gateway module.
QUOTED_STRING
Name of the existing Gateway m odule in quotes.
OMBDROP, OMBCREATE GATEWAY_MODULE, OMBALTER GATEWAY_MODULE
To remove an iconset from the workspace.
Any context.
dropIconSetCommand = OMBDROP ICONSET "QUOTED_STRING"
dropIconSetCommand
This command removes an iconset from the workspace.
QUOTED_STRING
The name of the iconset to be removed.
OMBCREATE ICONSET, OMBALTER ICONSET
To drop a transient import action plan.
In the context of a project
dropImportActionPlanCommand = ( OMBDROP ( IMPORT_ACTION_PLAN ) "QUOTED_STRING" )
dropImportActionPlanCommand
This command is for dropping an import action plan.
QUOTED_STRING
The name of the import action plan to be dropped.
OMBCREATE IMPORT_ACTION_PLAN, OMBIMPORT
To drop an Item Folder.
Should be in the context of a Business Definition Module or use the full
path.
dropItemFolderCommand = OMBDROP ITEM_FOLDER "QUOTED_STRING"
dropItemFolderCommand
To drop an Item Folder.
OMBRETRIEVE ITEM_FOLDER, OMBCREATE ITEM_FOLDER, OMBALTER ITEM_FOLDER
To drop a List Of Values.
Should be in the context of a Business Definition Module or use the full
path.
dropListOfValuesCommand = OMBDROP LIST_OF_VALUES "QUOTED_STRING"
dropListOfValuesCommand
To drop a List Of Values.
OMBRETRIEVE LIST_OF_VALUES, OMBCREATE LIST_OF_VALUES, OMBALTER LIST_OF_VALUES
Delete the location.
Can be in any context.
dropLocationCommand = OMBDROP ( LOCATION "QUOTED_STRING" )
dropLocationCommand
Drop a location from the repository.
OMBDROP, OMBCREATE LOCATION, OMBALTER LOCATION
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, OMBCREATE MAPPING, OMBALTER MAPPING, OMBRETRIEVE MAPPING
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, OMBCREATE MATERIALIZED_VIEW, OMBALTER MATERIALIZED_VIEW, OMBRETRIEVE MATERIALIZED_VIEW
Remove an existing metadata loader action plan.
Connection must be established to the repository.
dropMDLActionPlanCommand = ( OMBDROP ( MDL_ACTION_PLAN ) "QUOTED_STRING" )
dropMDLActionPlanCommand
Remove an existing metadata loader action plan.
QUOTED_STRING
Enclose the name of the metadata loader action plan in single quotes.
OMBCREATE MDL_ACTION_PLAN, OMBALTER MDL_ACTION_PLAN, OMBRETRIEVE MDL_ACTION_PLAN, OMUEXPORT MDL_FILE
Delete the Nested Table.
Should be in the context of an Oracle Module.
dropNestedTableCommand = OMBDROP NESTED_TABLE "QUOTED_STRING"
OMBRETRIEVE NESTED_TABLE, OMBCREATE NESTED_TABLE, OMBALTER NESTED_TABLE
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, OMBCREATE OBJECT_TYPE, OMBALTER OBJECT_TYPE
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, OMBCREATE ORACLE_MODULE, OMBALTER ORACLE_MODULE
Delete the Package.
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.
dropPackageCommand = OMBDROP ( PACKAGE "QUOTED_STRING" )
dropPackageCommand
Remove an existing Package.
QUOTED_STRING
Name of the existing Package in quotes.
OMBDROP, OMBCREATE PACKAGE, OMBALTER PACKAGE
Delete the PLSQL Record Type.
Should be in the context of a Package.
dropPlSqlRecordTypeCommand = OMBDROP PLSQL_RECORD_TYPE "QUOTED_STRING"
dropPlSqlRecordTypeCommand
Drops the PLSQL Record Type with given name.
OMBDROP, OMBCREATE PLSQL_RECORD_TYPE, OMBALTER PLSQL_RECORD_TYPE
Delete the Ref-cursor Type.
Should be in the context of a Package.
dropPlSqlRefCursorTypeCommand = OMBDROP PLSQL_REF_CURSOR_TYPE "QUOTED_STRING"
dropPlSqlRefCursorTypeCommand
Drops the Ref-cursor Type with given name.
OMBDROP, OMBCREATE PLSQL_REF_CURSOR_TYPE, OMBALTER PLSQL_REF_CURSOR_TYPE
Delete the Table Type.
Should be in the context of a Package.
dropPlSqlTableTypeCommand = OMBDROP PLSQL_TABLE_TYPE "QUOTED_STRING"
dropPlSqlTableTypeCommand
Drops the Table Type with given name.
OMBDROP, OMBCREATE PLSQL_TABLE_TYPE, OMBALTER PLSQL_TABLE_TYPE
Drop an existing pluggable map folder.
The current context of scripting must be a project.
dropPluggableMappingFolderCommand = OMBDROP PLUGGABLE_MAPPING_FOLDER "pluggableMapFolderName" pluggableMapFolderName = "QUOTED_STRING"
dropPluggableMappingFolderCommand
Drop an existing pluggable map folder.
pluggableMapFolderName
Name of the pluggable map folder.
OMBDROP
Drop an existing pluggable mapping.
The current context of scripting must be a project or pluggable map folder.
dropPluggableMappingCommand = OMBDROP PLUGGABLE_MAPPING "pluggableMapName" pluggableMapName = "QUOTED_STRING"
dropPluggableMappingCommand
Drop an existing pluggable map folder.
pluggableMapName
Name of the pluggable map.
OMBDROP, OMBCREATE PLUGGABLE_MAPPING, OMBALTER PLUGGABLE_MAPPING, OMBRETRIEVE PLUGGABLE_MAPPING
To drop a presentation template.
Should be in the context of a business presentation module or use the full
path.
dropReportCommand = OMBDROP PRESENTATION_TEMPLATE "QUOTED_STRING"
dropReportCommand
To drop a presentation template.
OMBRETRIEVE PRESENTATION_TEMPLATE, OMBCREATE PRESENTATION_TEMPLATE, OMBALTER PRESENTATION_TEMPLATE
Delete the Procedure.
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.
dropProcedureCommand = OMBDROP ( PROCEDURE "QUOTED_STRING" )
dropProcedureCommand
Remove an existing Procedure.
QUOTED_STRING
Name of the existing Procedure in quotes.
OMBDROP, OMBCREATE PROCEDURE, OMBALTER PROCEDURE
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, OMBCREATE PROCESS_FLOW, OMBALTER PROCESS_FLOW
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, OMBCREATE PROCESS_FLOW_MODULE, OMBALTER PROCESS_FLOW_MODULE
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, OMBCREATE PROCESS_FLOW_PACKAGE, OMBALTER PROCESS_FLOW_PACKAGE
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, OMBCREATE PROJECT, OMBALTER PROJECT
Delete the Queue Propagation.
Should be in the context of an Advanced Queue.
dropQPCommand = OMBDROP QUEUE_PROPAGATION "QUOTED_STRING"
dropQPCommand
Drops the Queue Propagation with the given name.
OMBDROP, OMBCREATE QUEUE_PROPAGATION, OMBALTER QUEUE_PROPAGATION, OMBRETRIEVE QUEUE_PROPAGATION
Delete the Queue Table.
Should be in the context of an Oracle Module.
dropQTCommand = OMBDROP QUEUE_TABLE "QUOTED_STRING"
dropQTCommand
Drops the Queue Table with the given name.
OMBDROP, OMBCREATE QUEUE_TABLE, OMBALTER QUEUE_TABLE, OMBRETRIEVE QUEUE_TABLE
Drop an existing Real Time mapping.
The current context of scripting must be an Oracle
dropRealTimeMappingCommand = OMBDROP REAL_TIME_MAPPING "mappingName" mappingName = "QUOTED_STRING"
mappingName
Name of the mapping.
OMBDROP, OMBCREATE REAL_TIME_MAPPING, OMBALTER REAL_TIME_MAPPING, OMBRETRIEVE REAL_TIME_MAPPING
To drop an IO Function.
Should be in the context of a Business Definition Module or use the full
path.
dropRegisteredFunctionCommand = OMBDROP REGISTERED_FUNCTION "QUOTED_STRING"
dropRegisteredFunctionCommand
To drop an IO Function.
OMBRETRIEVE REGISTERED_FUNCTION, OMBCREATE REGISTERED_FUNCTION, OMBALTER REGISTERED_FUNCTION
To drop a Warehouse Builder role.
Must be connected to a workspace on OWB repository.
parseDropRoleCommand = ( OMBDROP ROLE "QUOTED_STRING" )
parseDropRoleCommand
This clause drops a Warehouse Builder role.
OMBCREATE ROLE, OMBALTER ROLE, OMBRETRIEVE ROLE, OMBLIST ROLES
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
To drop a sequence.
In the context of an Oracle Module.
dropSequenceCommand = OMBDROP SEQUENCE "QUOTED_STRING"
dropSequenceCommand
This clause drops a Sequence.
OMBDROP, OMBCREATE SEQUENCE, OMBALTER SEQUENCE, OMBRETRIEVE SEQUENCE
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.
OMBCREATE SNAPSHOT, OMBALTER SNAPSHOT, OMBRESTORE SNAPSHOT, OMBCOMPARE SNAPSHOT, OMBLIST SNAPSHOT, OMBRETRIEVE SNAPSHOT
Delete the Streams Capture Process.
Should be in the context of a Streams Queue.
dropCaptureCommand = OMBDROP STREAMS_CAPTURE_PROCESS "QUOTED_STRING"
dropCaptureCommand
Drops the Streams Capture Process with the given name.
OMBDROP, OMBCREATE STREAMS_CAPTURE_PROCESS, OMBALTER STREAMS_CAPTURE_PROCESS, OMBRETRIEVE STREAMS_CAPTURE_PROCESS
Delete the Streams Queue.
Should be in the context of an Oracle Module.
dropANYQCommand = OMBDROP STREAMS_QUEUE "QUOTED_STRING"
dropANYQCommand
Drops the Streams Queue with the given name.
OMBDROP, OMBCREATE STREAMS_QUEUE, OMBALTER STREAMS_QUEUE, OMBRETRIEVE STREAMS_QUEUE
Delete the Table Function.
Should be in the context of Oracle Module or Package.
dropTableFunctionCommand = OMBDROP ( TABLE_FUNCTION "QUOTED_STRING" )
dropTableFunctionCommand
Drops a Table Function
OMBDROP, OMBCREATE TABLE_FUNCTION, OMBALTER TABLE_FUNCTION
To drop a table.
In the context of an Oracle Module.
dropTableCommand = OMBDROP TABLE "QUOTED_STRING"
dropTableCommand
This clause drops a table.
OMBDROP, OMBCREATE TABLE, OMBALTER TABLE, OMBRETRIEVE TABLE
This command drops a time dimension.
Should be in Oracle Module context.
dropTimeDimensionCommand = OMBDROP TIME_DIMENSION "TimeDimensionName" TimeDimensionName = "QUOTED_STRING"
TimeDimensionName
The name of the time dimension.
OMBCREATE TIME_DIMENSION, OMBALTER TIME_DIMENSION, OMBRETRIEVE TIME_DIMENSION
To drop a transportable module.
In the context of a project.
dropTMCommand = OMBDROP TRANSPORTABLE_MODULE "QUOTED_STRING"
dropTMCommand
This command is for dropping a transportable module.
QUOTED_STRING
The transportable module to be dropped.
OMBCREATE TRANSPORTABLE_MODULE
Delete the Varying Array.
Should be in the context of an Oracle Module.
dropVaryingArrayCommand = OMBDROP VARYING_ARRAY "QUOTED_STRING"
OMBRETRIEVE VARYING_ARRAY, OMBCREATE VARYING_ARRAY, OMBALTER VARYING_ARRAY