Skip Headers
Oracle® Warehouse Builder Scripting Reference
10
g
Release 1 (10.1)
Part No. B12152-01
Contents
Title and Copyright Information
Send Us Your Comments
Preface
Purpose
Audience
How This Guide Is Organized
New in 10
g
Release 1 (10.1)
Added in Release 2 (9.0.4)
Conventions
Related Publications
Documentation Accessibility
Contacting Oracle
1
Introduction
About the OMB Scripting Language
Using OMB Plus
Launching OMB Plus
Connecting to a Repository
Writing OMB Plus Commands
Running Scripts in OMB Plus
Locating Errors in Scripts and Multi-line Commands
Predefined Tcl Procedures
OMB Plus Commands
Metadata Manipulation Language (MML) Commands
Examples
Warehouse Builder Metadata Objects
Shell Commands
OMBHELP
OMBENV
Administrative Commands
Navigation Commands
OMBCC
OMBDCC
OMBLIST
Service Commands
Synchronizing Cached Data with Repository Objects
How to Read Syntax Diagrams
Required Keywords and Parameters
Optional Keywords and Parameters
Syntax Loops
Sample OMB Plus Scripts
Updating a Design Repository
Reporting on Repository Objects
Finding Invalid Objects
Using OMB Plus to Navigate Repositories
2
OMB Plus Commands
OMBCC
OMBCOMMIT
OMBCOMPARE_SNAPSHOT
OMBCOMPILE
OMBCONN
OMBCONNECT_RUNTIME
OMBCONNECT
OMBCOPY
OMBDCC
OMBDEPLOY
OMBDESCRIBE_CLASS_DEFINITION
OMBDISC
OMBDISCONNECT
OMBENV
OMBEXPORT
OMBEXPORT_MDL_FILE
OMBHELP
OMBIMPORT
OMBIMPORT_MDL_FILE
OMBLIST
OMBLIST_SNAPSHOT
OMBLOCK
OMBMOVE
OMBRECONCILE
OMBREDEFINE_CLASS_DEFINITION
OMBREGISTER_LOCATION
OMBRESTORE_SNAPSHOT
OMBROLLBACK
OMBUNLOCK
OMBVALIDATE
3
OMBALTER
OMBALTER
OMBALTER ADVANCED_QUEUE
OMBALTER COLLECTION
OMBALTER CONNECTOR
OMBALTER CUBE_TABLE
OMBALTER DEPLOYEMENT_ACTION_PLAN
OMBALTER EXTERNAL_TABLE
OMBALTER FLAT_FILE
OMBALTER FLAT_FILE_MODULE
OMBALTER FUNCTION
OMBALTER LOCATION
OMBALTER MAPPING
OMBALTER MATERIALIZED_VIEW
OMBALTER OBJECT_TYPE
OMBALTER ORACLE_MODULE
OMBALTER PACKAGE
OMBALTER PROCEDURE
OMBALTER PROCESS_FLOW
OMBALTER PROCESS_FLOW_MODULE
OMBALTER PROCESS_FLOW_PACKAGE
OMBALTER PROJECT
OMBALTER RUNTIME_REPOSITORY_CONNECTIONS
OMBALTER SEQUENCE
OMBALTER SNAPSHOT
OMBALTER TABLE
OMBALTER VIEW
4
OMBCREATE
OMBCREATE
OMBCREATE ADVANCED_QUEUE
OMBCREATE COLLECTION
OMBCREATE CONNECTOR
OMBCREATE CUBE_TABLE
OMBCREATE DEPLOYEMENT_ACTION_PLAN
OMBCREATE EXTERNAL_TABLE
OMBCREATE FLAT_FILE
OMBCREATE FLAT_FILE_MODULE
OMBCREATE FUNCTION
OMBCREATE LOCATION
OMBCREATE MAPPING
OMBCREATE MATERIALIZED_VIEW
OMBCREATE OBJECT_TYPE
OMBCREATE ORACLE_MODULE
OMBCREATE PACKAGE
OMBCREATE PROCEDURE
OMBCREATE PROCESS_FLOW
OMBCREATE PROCESS_FLOW_MODULE
OMBCREATE PROCESS_FLOW_PACKAGE
OMBCREATE PROJECT
OMBCREATE RUNTIME_REPOSITORY_CONNECTION
OMBCREATE SEQUENCE
OMBCREATE SNAPSHOT
OMBCREATE TABLE
OMBCREATE VIEW
5
OMBDROP
OMBDROP
OMBDROP ADVANCED_QUEUE
OMBDROP COLLECTION
OMBDROP CONNECTOR
OMBDROP CUBE_TABLE
OMBDROP DEPLOYEMENT_ACTION_PLAN
OMBDROP EXTERNAL_TABLE
OMBDROP FLAT_FILE
OMBDROP FLAT_FILE_MODULE
OMBDROP FUNCTION
OMBDROP GATEWAY_MODULE
OMBDROP LOCATION
OMBDROP MAPPING
OMBDROP MATERIALIZED_VIEW
OMBDROP OBJECT_TYPE
OMBDROP ORACLE_MODULE
OMBDROP PACKAGE
OMBDROP PROCEDURE
OMBDROP PROCESS_FLOW
OMBDROP PROCESS_FLOW_MODULE
OMBDROP PROCESS_FLOW_PACKAGE
OMBDROP PROJECT
OMBDROP RUNTIME_REPOSITORY_CONNECTION
OMBDROP SAP_MODULE
OMBDROP SEQUENCE
OMBDROP SNAPSHOT
OMBDROP TABLE
OMBDROP VIEW
6
OMBRETRIEVE
OMBRETRIEVE
OMBRETRIEVE ADVANCED_QUEUE
OMBRETRIEVE COLLECTION
OMBRETRIEVE CONNECTOR
OMBRETRIEVE CUBE_TABLE
OMBRETRIEVE DEPLOYEMENT_ACTION_PLAN
OMBRETRIEVE EXTERNAL_TABLE
OMBRETRIEVE FLAT_FILE
OMBRETRIEVE FLAT_FILE_MODULE
OMBRETRIEVE FUNCTION
OMBRETRIEVE GATEWAY_MODULE
OMBRETRIEVE LOCATION
OMBRETRIEVE MAPPING
OMBRETRIEVE MATERIALIZED_VIEW
OMBRETRIEVE OBJECT_TYPE
OMBRETRIEVE ORACLE_MODULE
OMBRETRIEVE PACKAGE
OMBRETRIEVE PROCEDURE
OMBRETRIEVE PROCESS_FLOW
OMBRETRIEVE PROCESS_FLOW_MODULE
OMBRETRIEVE PROCESS_FLOW_PACKAGE
OMBRETRIEVE PROJECT
OMBRETRIEVE RUNTIME_REPOSITORY_CONNECTION
OMBRETRIVE SAP_MODULE
OMBRETRIEVE SEQUENCE
OMBRETRIEVE SNAPSHOT
OMBRETRIEVE TABLE
OMBRETRIEVE VIEW
A
Running OMB Plus in Oracle JDeveloper
Installing OMB Plus in Oracle JDeveloper
Opening the Syntax Highlighting Editor in JDeveloper
Invoking Keyword Auto Completion
Invoking the OMBPlus Interpreter
Viewing the OMBPlus Console
Viewing Help Documentation
B
Default Groups and Parameters
Default Group Names and Attribute Names
