Skip Headers
Oracle® Warehouse Builder OMB*Plus Command Reference
11g Release 2 (11.2)
Part Number E14406-01
Go to Documentation Home
Home		 Go to Book List
Book List		 Go to Table of Contents
Contents		 Go to Master Index
Master Index		 Go to Feedback page
Contact Us
Go to previous page
Previous		 Go to next page
Next
 

OMBCREATE CONFIGURATION_TEMPLATE

Purpose

Create a configuration template that can be associated with a configuration.

Prerequisites

None.

Syntax

createConfigurationTemplateCommand =  OMBCREATE ( CONFIGURATION_TEMPLATE 
          "QUOTED_STRING" [ SET ( "setPropertiesClause" [ SET 
          "setReferenceIconSetClause" ] [ SET "setTemplateValuesClause" ] | 
          "setReferenceIconSetClause" [ SET "setTemplateValuesClause" ] | 
          "setTemplateValuesClause" ) ] )
     setPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     setReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET "QUOTED_STRING"
     setTemplateValuesClause =  ( TEMPLATE_VALUES "(" "propertyNameList" ")" TO 
          "(" "propertyValueList" ")" FOR "getType" )+ ON PLATFORM 
          "QUOTED_STRING"
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     getType =  "UNQUOTED_STRING"
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

createConfigurationTemplateCommand

Create a configuration template.

setPropertiesClause

Associate a set of properties with a configuration template.

getPropertiesClause

Basic properties for CONFIGURATION_TEMPLATE:

Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: NAME
Business name of a configuration template 

Name: DESCRIPTION
Type: STRING(4000)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Description of a configuration template

setReferenceIconSetClause

Associate an Icon Set with this configuration template.

setTemplateValuesClause

Specifies the configuration properties that will be overriden in this template for objects of a certain type on a certain platform.
The following is a list of configuration properties and their seeded default values:

Platform ObjectType {UI category}
  {UI name} ScriptingName {Default value}

DB2UDB DB2UDB_MODULE {GENERATION_TARGET_DIRECTORIES}
  {8i.DB2UDB.1.CTLDIRECTORY} LOADER_DIRECTORY {ctl\}
  {8i.DB2UDB.1.CTLEXTENSION} LOADER_EXTENSION {.ctl}
  {8i.DB2UDB.1.CTLRUNPRM} LOADER_RUN_PARAMETER_FILE {_run.ini}

DB2UDB FUNCTION {Identification}
  {Deployable} DEPLOYABLE {true}

DB2UDB FUNCTION {Options}
  {Deterministic} DETERMINISTIC_STATE {}
  {Language} LANGUAGE_SQL {}
  {SPECIFIC} SPECIFIC {}
  {Call On Null Input} CALLED_ON_NULL_INPUT {}
  {External Action} EXTERNAL_ACTION {}
  {Inherit Isolation Level} INHERIT_ISOLATION_LEVEL {}
  {Inherit Special Registers} INHERIT_SPECIAL_REGISTERS {}
  {Parameter Ccsid} PARAMETER_CCSID {}
  {SQL Data} SQL_DATA {}
  {Static Dispatch} STATIC_DISPATCH {}

DB2UDB FUNCTION {}
  {Generation Comments} GENERATION_COMMENTS {}

DB2UDB TABLE {Change Data Capture}
  {Enable} IS_CDC {false}
  {Table Position} CDC_POSITION {0}

GENERIC ALTERNATIVE_SORT_ORDER {Identification}
  {Deployable} DEPLOYABLE {true}

GENERIC BUSINESS_AREA {Identification}
  {Deployable} DEPLOYABLE {true}

GENERIC BUSINESS_DEFINITION_MODULE {Identification}
  {Deployable} DEPLOYABLE {true}

GENERIC BUSINESS_DEFINITION_MODULE {Discoverer Import Options}
  {Object Matching} OBJECT_MATCHING {BY_IDENTIFIER}

GENERIC CATALOG_FOLDER {Identification}
  {Deployable} DEPLOYABLE {true}

GENERIC DRILL_TO_DETAIL {Identification}
  {Deployable} DEPLOYABLE {true}

GENERIC EJB {Execution Settings}
  {Use Return as Status} USE_RETURN_AS_STATUS {false}

GENERIC FOR_LOOP {Execution Settings}
  {Use Return as Status} USE_RETURN_AS_STATUS {false}

GENERIC JAVA {Execution Settings}
  {Use Return as Status} USE_RETURN_AS_STATUS {false}

GENERIC LIST_OF_VALUES {Identification}
  {Deployable} DEPLOYABLE {true}

GENERIC OBIEEDRILL_PATH {Identification}
  {Deployable} DEPLOYABLE {true}

GENERIC OBIEEQUERY_OBJECT_SIMPLE {Identification}
  {Deployable} DEPLOYABLE {true}

GENERIC OBIEE_BUSINESS_DEFINITION_MODULE {Identification}
  {Deployable} DEPLOYABLE {true}

GENERIC OBISEDRILL_PATH {Identification}
  {Deployable} DEPLOYABLE {true}

GENERIC OBISEQUERY_OBJECT_SIMPLE {Identification}
  {Deployable} DEPLOYABLE {true}
  {Optimizer Hint} OPTIMIZER_HINT {}

GENERIC OMBPLUS {Execution Settings}
  {Use Return as Status} USE_RETURN_AS_STATUS {false}

GENERIC PROCESS_ACTIVITY {Execution Settings}
  {Use Return as Status} USE_RETURN_AS_STATUS {false}

GENERIC PROCESS_FLOW {}
  {Generation Comments} GENERATION_COMMENTS {}
  {Referred Calendar} REFERRED_CALENDAR {}

GENERIC PROCESS_FLOW_PACKAGE {IDENTIFICATION}
  {OWF.PACKAGES.DEPLOYABLE} DEPLOYABLE {true}

GENERIC PROCESS_FLOW_PACKAGE {}
  {Generation Comments} GENERATION_COMMENTS {}

GENERIC REGISTERED_FUNCTION {Identification}
  {Deployable} DEPLOYABLE {true}
  {Package} PACKAGE {}

GENERIC REGISTERED_FUNCTION {Options}
  {AUTHID} AUTHID {}
  {Deterministic} IS_DETERMINISTIC {}
  {Parallel Enable} IS_PARALLEL_ENABLE {}
  {Pragma Autonomous Transaction} PRAGMA_AUTONOMOUS_TRANSACTION {}

GENERIC REGISTERED_FUNCTION {}
  {Generation Comments} GENERATION_COMMENTS {}

GENERIC SEQUENCE {}
  {Generation Comments} GENERATION_COMMENTS {}

GENERIC TABLE {Change Data Capture}
  {Enable} IS_CDC {false}

GENERIC VIEW {}
  {Generation Comments} GENERATION_COMMENTS {}

GENERIC WEBSERVICE {Execution Settings}
  {Use Return as Status} USE_RETURN_AS_STATUS {false}

GENERIC AND ACTIVITY {Execution Settings}
  {Use Return as Status} USE_RETURN_AS_STATUS {false}

GENERIC ASSIGN ACTIVITY {Execution Settings}
  {Use Return as Status} USE_RETURN_AS_STATUS {false}

GENERIC DATA_AUDITOR ACTIVITY {Execution Settings}
  {Use Return as Status} USE_RETURN_AS_STATUS {false}

GENERIC EMAIL ACTIVITY {Execution Settings}
  {Use Return as Status} USE_RETURN_AS_STATUS {false}

GENERIC END ACTIVITY {Execution Settings}
  {Use Return as Status} USE_RETURN_AS_STATUS {false}

GENERIC END_ERROR ACTIVITY {Execution Settings}
  {Use Return as Status} USE_RETURN_AS_STATUS {false}

GENERIC END_LOOP ACTIVITY {Execution Settings}
  {Use Return as Status} USE_RETURN_AS_STATUS {false}

GENERIC END_SUCCESS ACTIVITY {Execution Settings}
  {Use Return as Status} USE_RETURN_AS_STATUS {false}

GENERIC END_WARNING ACTIVITY {Execution Settings}
  {Use Return as Status} USE_RETURN_AS_STATUS {false}

GENERIC EVENT_LISTENER ACTIVITY {Execution Settings}
  {Use Return as Status} USE_RETURN_AS_STATUS {false}

GENERIC FILE_EXISTS ACTIVITY {Execution Settings}
  {Use Return as Status} USE_RETURN_AS_STATUS {false}

GENERIC FORK ACTIVITY {Execution Settings}
  {Use Return as Status} USE_RETURN_AS_STATUS {false}

GENERIC FTP ACTIVITY {Execution Settings}
  {Use Return as Status} USE_RETURN_AS_STATUS {false}

GENERIC MANUAL ACTIVITY {Execution Settings}
  {Use Return as Status} USE_RETURN_AS_STATUS {false}

GENERIC MAPPING ACTIVITY {Execution Settings}
  {Use Return as Status} USE_RETURN_AS_STATUS {false}

GENERIC NOTIFICATION ACTIVITY {Execution Settings}
  {Use Return as Status} USE_RETURN_AS_STATUS {false}

GENERIC OR ACTIVITY {Execution Settings}
  {Use Return as Status} USE_RETURN_AS_STATUS {false}

GENERIC PREDICT ACTIVITY {Execution Settings}
  {Use Return as Status} USE_RETURN_AS_STATUS {false}

GENERIC ROUTE ACTIVITY {Execution Settings}
  {Use Return as Status} USE_RETURN_AS_STATUS {false}

GENERIC SET_STATUS ACTIVITY {Execution Settings}
  {Use Return as Status} USE_RETURN_AS_STATUS {false}

GENERIC SQLPLUS ACTIVITY {Execution Settings}
  {Use Return as Status} USE_RETURN_AS_STATUS {false}

GENERIC START ACTIVITY {Execution Settings}
  {Use Return as Status} USE_RETURN_AS_STATUS {false}

GENERIC SUBPROCESS ACTIVITY {Execution Settings}
  {Use Return as Status} USE_RETURN_AS_STATUS {false}

GENERIC TRANSFORMATION ACTIVITY {Execution Settings}
  {Use Return as Status} USE_RETURN_AS_STATUS {false}

GENERIC USER_DEFINED ACTIVITY {Execution Settings}
  {Use Return as Status} USE_RETURN_AS_STATUS {false}

GENERIC WAIT ACTIVITY {Execution Settings}
  {Use Return as Status} USE_RETURN_AS_STATUS {false}

GENERIC WHILE_LOOP ACTIVITY {Execution Settings}
  {Use Return as Status} USE_RETURN_AS_STATUS {false}

J2EE WEB_SERVICE {IDENTIFICATION}
  {Deployable} DEPLOYABLE {true}

J2EE WEB_SERVICE_PACKAGE {IDENTIFICATION}
  {Deployable} DEPLOYABLE {true}

ORACLE BATCH_MAPPING {CODE_GENERATION_OPTIONS}
  {MAP.AUTHID} AUTHID {None}
  {Analyze table statements} ANALYZE_TABLE_STATEMENTS {false}
  {ANSI SQL Syntax } ANSI_SQL_SYNTAX {true}
  {Bulk processing code} BULK_PROCESSING_CODE {true}
  {Commit Control} COMMIT_CONTROL {AUTO_COMMIT}
  {Enable Parallel DML} ENABLE_PARALLEL_DML {false}
  {Error Trigger} ERROR_TRIGGER {}
  {Generation Mode} GENERATION_MODE {ALL_MODES}
  {Optimized code} OPTIMIZED_CODE {true}
  {Use Target Load Ordering} TARGET_LOAD_ORDERING {true}

ORACLE BATCH_MAPPING {TDF}
  {Backports} BACKPORT_TRANSFORMS {}
  {Extends} EXTENDED_TRANSFORMS {}
  {Fixes} FIXED_TRANSFORMS {}
  {Handler} HANDLER_TRANSFORM {}
  {Release} TRANSFORM_RELEASE {}
  {Replaces} REPLACED_TRANSFORMS {}
  {ADXML Comments} ADXML_COMMENTS {}
  {Associated Partial Backport } ASSOCIATED_PARTIAL_BACKPORT_TRANSFORMS {}
  {Customer Notes} CUSTOMER_NOTES {}
  {Deploy Condition} DEPLOY_CONDITION {}
  {Dev Version} DEV_VERSION {}
  {Developer Notes} DEVELOPER_NOTES {}
  {Handler Of} HANDLER_OF_TRANSFORMS {}
  {Must Run After} MUST_RUN_AFTER_TRANSFORMS {}
  {Partial Backports} PARTIAL_BACKPORT_TRANSFORMS {}

ORACLE BATCH_MAPPING {PL/SQL mapping debugger properties for stage}
  {Debug runtime connection.} DEBUG_RUNTIME_CONNECTION {}

ORACLE BATCH_MAPPING {Runtime parameters}
  {Audit} AUDIT {true}
  {ABAP Report Name} ABAP_REPORT_NAME {}
  {Analyze table sample percentage} ANALYZE_TABLE_SAMPLE_PERCENTAGE {5}
  {Background Job} BACKGROUND {false}
  {Bulk size} BULK_SIZE {1000}
  {Commit frequency} COMMIT_FREQUENCY {1000}
  {Data File Name} DATA_FILE_NAME {}
  {Default audit level} DEFAULT_AUDIT_LEVEL {ERROR_DETAILS}
  {Default Operating Mode} DEFAULT_OPERATING_MODE {SET_BASED_FAIL_OVER_TO_ROW_BASED}
  {Default purge group} DEFAULT_PURGE_GROUP {WB}
  {File Delimiter for Staging File} FILE_DELIMITER_FOR_STAGING_FILE {~}
  {Include FTP} SAP_FTP {true}
  {Maximum number of errors} MAXIMUM_NUMBER_OF_ERRORS {50}
  {Nested Loop} NESTED_LOOP {TRUE_DEFAULT}
  {Primary Foreign Key for Join} PRIMARY_FOREIGN_KEY_FOR_JOIN {DEFAULT}
  {SAP System Version} SAP_SYSTEM_VERSION {SAP_R3_4X}
  {Sql Join Collapsing} SQL_JOIN_COLLAPSING {TRUE_DEFAULT}
  {Staging File Directory} STAGING_FILE_DIRECTORY {C:\temp\}
  {Use Select Single} USE_SELECT_SINGLE {TRUE_DEFAULT}

ORACLE BATCH_MAPPING {SQL Loader Settings}
  {Multithreading} MULTITHREADING {USE_DEFAULT}
  {Resumable} RESUMABLE {false}
  {Bind Size} BIND_SIZE {50000}
  {Byte Order Mark} BYTE_ORDER_MARK {NOT_APPLICABLE}
  {Column Array Rows} COLUMNARRAYROWS {0}
  {Continue Load} CONTINUE_LOAD {false}
  {Control File Name} CONTROL_FILE_NAME {}
  {Database File Name} DATABASE_FILE_NAME {}
  {Delimited File Record Termination} DELIMITED_FILE_RECORD_TERMINATION {}
  {Direct Mode} DIRECT_MODE {false}
  {Endian (Byte Order)} BYTE_ORDER {DEFAULT_TO_PLATFORM}
  {Errors Allowed} ERRORS_ALLOWED {50}
  {Load Last Field As Pieced} LOAD_LAST_FIELD_AS_PIECED {false}
  {Log File Name} LOG_FILE_NAME {}
  {Nls Characterset} NLS_CHARACTERSET {}
  {Operation Recoverable} OPERATION_RECOVERABLE {true}
  {Perform Parallel Load} PERFORM_PARALLEL_LOAD {false}
  {Preserve Blanks} PRESERVE_BLANKS {false}
  {Read Buffers} READ_BUFFERS {0}
  {Read Size} READ_SIZE {65536}
  {Records to Load} RECORDS_TO_LOAD {0}
  {Records to Skip} RECORDS_TO_SKIP {0}
  {Resumable Name} RESUMABLE_NAME {}
  {Resumeable Timeout} RESUMABLE_TIMEOUT {7200}
  {Rows per Commit} ROWS_PER_COMMIT {200}
  {Skip Index Maintenance} SKIP_INDEX_MAINTENANCE {false}
  {Skip Unusable Indexes} SKIP_UNUSABLE_INDEXES {USE_DATABASE_CONFIG}
  {Stream size} STREAM_SIZE {0}
  {Supress discards} SUPRESS_DISCARDS {false}
  {Supress Errors} SUPRESS_ERRORS {false}
  {Supress Feedback} SUPRESS_FEEDBACK {false}
  {Supress Header} SUPRESS_HEADER {false}
  {Supress partitions} SUPRESS_PARTITIONS {false}

ORACLE BATCH_MAPPING {SQL*Plus Settings}
  {ARRAYSIZE} ARRAYSIZE {15}
  {COPYCOMMIT} COPYCOMMIT {0}
  {LONG} LONG_SIZE {2000000}
  {LOG File Directory} LOG_FILE_DIRECTORY {}
  {LOG File Name} LOG_FILE_NAME_SQLPLUS {}
  {SQL File Directory} SQL_FILE_DIRECTORY {}
  {SQL File Name} SQL_FILE_NAME {}

ORACLE BATCH_MAPPING {}
  {Deployable} DEPLOYABLE {true}
  {Language} GENERATION_LANGUAGE {UNDEFINED}
  {Generation Comments} GENERATION_COMMENTS {}
  {Referred Calendar} REFERRED_CALENDAR {}

ORACLE CUBE {Identification}
  {Deployable} DEPLOYABLE {true}
  {Visible} VISIBLE {true}
  {Deployment Options} DEPLOYMENT_OPTIONS {DEPLOY_DATA_OBJECTS_ONLY}
  {Materialized View Index Tablespace} MATERIALIZED_VIEW_INDEX_TABLESPACE {USERS}
  {Materialized View Tablespace} MATERIALIZED_VIEW_TABLESPACE {USERS}

ORACLE CUBE {Summary Management}
  {Cost Based Aggregation} COSTBASEDPERCENTAGE {0}
  {Enable MV Refresh} ENABLE_MV_REFRESH {false}
  {Enable Query Rewrite} QUERY_REWRITE {DISABLE}
  {MV Constraints} MVCONSTRAINTS {TRUSTED}
  {Refresh Mode} REFRESH {FORCE}
  {Refresh Next Date} NEXTDATE {}
  {Refresh On} REFRESH_ON {DEMAND}
  {Refresh Start Date} STARTWITH {}

ORACLE CUBE {}
  {Generation Comments} GENERATION_COMMENTS {}

ORACLE DATA_AUDITOR {Code generation options}
  {Analyze table statements} ANALYZE_TABLE_STATEMENTS {true}
  {ANSI SQL Syntax } ANSI_SQL_SYNTAX {true}
  {Bulk processing code} BULK_PROCESSING_CODE {true}
  {Commit Control} COMMIT_CONTROL {AUTO_COMMIT}
  {Enable Parallel DML} ENABLE_PARALLEL_DML {true}
  {Error Trigger} ERROR_TRIGGER {}
  {Generation Mode} GENERATION_MODE {SET_BASED}
  {Optimized code} OPTIMIZED_CODE {true}
  {Use Target Load Ordering} TARGET_LOAD_ORDERING {true}

ORACLE DATA_AUDITOR {PL/SQL mapping debugger properties for stage}
  {Debug runtime connection.} DEBUG_RUNTIME_CONNECTION {}

ORACLE DATA_AUDITOR {Runtime parameters}
  {Analyze table sample percentage} ANALYZE_TABLE_SAMPLE_PERCENTAGE {90}
  {Bulk size} BULK_SIZE {50}
  {Commit frequency} COMMIT_FREQUENCY {1000}
  {Default audit level} DEFAULT_AUDIT_LEVEL {STATISTICS}
  {Default Operating Mode} DEFAULT_OPERATING_MODE {SET_BASED}
  {Default purge group} DEFAULT_PURGE_GROUP {WB}
  {Maximum number of errors} MAXIMUM_NUMBER_OF_ERRORS {50}

ORACLE DATA_AUDITOR {}
  {Deployable} DEPLOYABLE {true}
  {Language} GENERATION_LANGUAGE {UNDEFINED}
  {Generation Comments} GENERATION_COMMENTS {}
  {Referred Calendar} REFERRED_CALENDAR {}
  {Threshold Mode} THRESHOLD_MODE {PERCENTAGE}

ORACLE DATA_PROFILE {Identification}
  {Deployable} DEPLOYABLE {true}
  {Application Short Name} APPLICATION_SHORT_NAME {WB}
  {Main Application Short Name} MAIN_APPLICATION_SHORT_NAME {ora}
  {Top Directory} TOP_DIRECTORY {..\..\codegen\}

ORACLE DATA_PROFILE {Deployment System Type}
  {PL/SQL Generation Mode} PLSQL_GENERATION_MODE {Default}

ORACLE DATA_PROFILE {Generation Preferences}
  {End of Line} END_OF_LINE {\r\n}

ORACLE DATA_PROFILE {Generation Target Directories}
  {8i.ORACLE8.1.SQLPLUSDIRECTORY} SQLPLUS_DIRECTORY {sqlplus\}
  {8i.ORACLE8.1.SQLPLUSEXTENSION} SQLPLUS_EXTENSION {.sql}
  {8i.ORACLE8.1.SQLPLUSRUNPRM} SQLPLUS_RUN_PARAMETER_FILE {_run.ini}
  {8i.ORACLE8.1.ZDTTDFEXTENSION} ZDT_EXTENSION {.tdf}
  {ABAP Extension} ABAP_EXTENSION {.abap}
  {ABAP Run Parameter File} ABAP_RUN_PARAMETER_FILE {_run.ini}
  {ABAP Spool Directory} ABAP_SPOOL_DIRECTORY {abap\log\}
  {DDL Directory} DDL_DIRECTORY {ddl\}
  {DDL Extension} DDL_EXTENSION {.ddl}
  {DDL Spool Directory} DDL_SPOOL_DIRECTORY {ddl\log\}
  {LIB Directory} LIB_DIRECTORY {lib\}
  {LIB Extension} LIB_EXTENSION {.lib}
  {LIB Spool Directory} LIB_SPOOL_DIRECTORY {lib\log\}
  {LOADER Directory} LOADER_DIRECTORY {ctl\}
  {LOADER Extension} LOADER_EXTENSION {.ctl}
  {LOADER Run Parameter File} LOADER_RUN_PARAMETER_FILE {_run.ini}
  {PL/SQL Directory} PLSQL_DIRECTORY {pls\}
  {PL/SQL Extension} PLSQL_EXTENSION {.pls}
  {PL/SQL Run Parameter File} PLSQL_RUN_PARAMETER_FILE {_run.ini}
  {PL/SQL Spool Directory} PLSQL_SPOOL_DIRECTORY {pls\log\}
  {Staging File Directory} ABAP_DIRECTORY {/tmp}
  {TCL Directory} TCL_DIRECTORY {tcl\}

ORACLE DATA_PROFILE {Run Time Directories}
  {Archive Directory} ARCHIVE_DIRECTORY {archive\}
  {Input Directory} INPUT_DIRECTORY {input\}
  {Invalid Directory} INVALID_DIRECTORY {invalid\}
  {Log Directory} LOG_DIRECTORY {log\}
  {Receive Directory} RECEIVE_DIRECTORY {receive\}
  {Sort Directory} SORT_DIRECTORY {sort\}
  {Work Directory} WORK_DIRECTORY {work\}

ORACLE DATA_PROFILE {Tablespace Defaults}
  {Default Index Tablespace} DEFAULT_INDEX_TABLESPACE {}
  {Default Object Tablespace} DEFAULT_OBJECT_TABLESPACE {}

ORACLE DIMENSION {Identification}
  {Deployable} DEPLOYABLE {true}
  {Visible} VISIBLE {true}
  {Deployment Options} DEPLOYMENT_OPTIONS {DEPLOY_DATA_OBJECTS_ONLY}
  {View Name} VIEW_NAME {}

ORACLE DIMENSION {Summary Management}
  {Enable MV Refresh} ENABLE_MV_REFRESH {false}
  {MV Constraints} MVCONSTRAINTS {TRUSTED}
  {Refresh Mode} REFRESH {FORCE}
  {Refresh Next Date} NEXTDATE {}
  {Refresh On} REFRESH_ON {DEMAND}
  {Refresh Start Date} STARTWITH {}

ORACLE DIMENSION {}
  {Generation Comments} GENERATION_COMMENTS {}

ORACLE EXTERNAL_TABLE {Identification}
  {Deployable} DEPLOYABLE {true}
  {Error Table Only} GENERATE_ERROR_TABLE_ONLY {false}

ORACLE EXTERNAL_TABLE {Parallel}
  {Parallel Access Drivers} PARALLEL_ACCESS_DRIVERS {1}
  {Parallel Access Mode} PARALLEL_ACCESS_MODE {false}

ORACLE EXTERNAL_TABLE {Reject}
  {Number Of Rejects Allowed} NUMBER_OF_REJECTS_ALLOWED {0}
  {Rejects Are Unlimited} REJECTS_ARE_UNLIMITED {true}

ORACLE EXTERNAL_TABLE {Access Specification}
  {Bad File Name} BAD_FILE_NAME {}
  {Discard File Name} DISCARD_FILE_NAME {}
  {Log File Name} LOG_FILE_NAME {}

ORACLE EXTERNAL_TABLE {Data Characteristics}
  {Endian} ENDIAN {PLATFORM}
  {String Sizes In} STRING_SIZES_IN {BYTES}

ORACLE EXTERNAL_TABLE {Error Table}
  {Error Table Name} ERROR_TABLE_NAME {}
  {Error Tablespace} ERROR_TABLESPACE {}

ORACLE EXTERNAL_TABLE {Field Editing}
  {Trim} TRIM {NONE}
  {Load Nulls When Missing Values} LOAD_NULLS_WHEN_MISSING_VALUES {false}

ORACLE EXTERNAL_TABLE {}
  {Generation Comments} GENERATION_COMMENTS {}

ORACLE FUNCTION {Identification}
  {Deployable} DEPLOYABLE {true}

ORACLE FUNCTION {Options}
  {AUTHID} AUTHID {}
  {Deterministic} IS_DETERMINISTIC {}
  {Parallel Enable} IS_PARALLEL_ENABLE {}
  {Pragma Autonomous Transaction} PRAGMA_AUTONOMOUS_TRANSACTION {}

ORACLE FUNCTION {}
  {Generation Comments} GENERATION_COMMENTS {}

ORACLE MATERIALIZED_VIEW {Identification}
  {Deployable} DEPLOYABLE {true}
  {Error Table Only} GENERATE_ERROR_TABLE_ONLY {false}

ORACLE MATERIALIZED_VIEW {Parallel}
  {9i.MATERIALIZEDVIEWS.PARALLELDEGREE} PARALLEL_DEGREE {}
  {Parallel Access Mode} PARALLEL_ACCESS_MODE {}

ORACLE MATERIALIZED_VIEW {Default Index Options}
  {9i.MATERIALIZEDVIEWS.DEFAULTINDEXBUFFERPOOL} DEFAULTINDEXBUFFERPOOL {}
  {9i.MATERIALIZEDVIEWS.DEFAULTINDEXFREELISTGROUPS} DEFAULTINDEXFREELISTGROUPS {}
  {9i.MATERIALIZEDVIEWS.DEFAULTINDEXFREELISTS} DEFAULTINDEXFREELISTS {}
  {9i.MATERIALIZEDVIEWS.DEFAULTINDEXINITIAL} DEFAULTINDEXINITIAL {}
  {9i.MATERIALIZEDVIEWS.DEFAULTINDEXINITRANS} DEFAULTINDEXINITRANS {}
  {9i.MATERIALIZEDVIEWS.DEFAULTINDEXMAXEXTENTS} DEFAULTINDEXMAXEXTENTS {}
  {9i.MATERIALIZEDVIEWS.DEFAULTINDEXMAXTRANS} DEFAULTINDEXMAXTRANS {}
  {9i.MATERIALIZEDVIEWS.DEFAULTINDEXMINEXTENTS} DEFAULTINDEXMINEXTENTS {}
  {9i.MATERIALIZEDVIEWS.DEFAULTINDEXNEXT} DEFAULTINDEXNEXT {}
  {9i.MATERIALIZEDVIEWS.DEFAULTINDEXPCTINCREASE} DEFAULTINDEXPCTINCREASE {}
  {9i.MATERIALIZEDVIEWS.DEFAULTINDEXSTOREIN} DEFAULT_INDEX_TABLESPACE {}
  {Using Index Mode} USING_INDEX_MODE {}

ORACLE MATERIALIZED_VIEW {Error Table}
  {9i.MATERIALIZEDVIEWS.SHADOWTABLE.TABLENAME} ERROR_TABLE_NAME {}
  {9i.MATERIALIZEDVIEWS.SHADOWTABLE.TABLESPACE} ERROR_TABLESPACE {}

ORACLE MATERIALIZED_VIEW {Hash Partition Parameters}
  {Hash Partition Tablespace List} HASH_PARTITION_TABLESPACE_LIST {}

ORACLE MATERIALIZED_VIEW {Materialized View Parameters}
  {9i.MATERIALIZEDVIEWS.FORUPDATE} FOR_UPDATE {}
  {9i.MATERIALIZEDVIEWS.NEXTDATE} NEXTDATE {}
  {Build} BUILD {}
  {Constraints} CONSTRAINTS {}
  {On} REFRESH_ON {}
  {Refresh} REFRESH {}
  {Rollback} ROLLBACK {DEFAULT LOCAL}
  {Rollbacksegmentlocal} ROLLBACKSEGMENTLOCAL {}
  {Rollbacksegmentmaster} ROLLBACKSEGMENTMASTER {}
  {Startwith} STARTWITH {}
  {With} WITH_KEY {}
  {9i.MATERIALIZEDVIEWS.QUERY REWRITE} QUERY_REWRITE {}
  {Base Tables} BASE_TABLES {}
  {Reduced Precision} REDUCED_PRECISION {}

ORACLE MATERIALIZED_VIEW {Performance Parameters}
  {Buffer Cache } CACHE_MODE {}
  {Data Segment Compression} DATA_SEGMENT_COMPRESSION {}
  {Logging Mode} LOGGING_MODE {}

ORACLE MATERIALIZED_VIEW {Physical Attributes}
  {9i.MATERIALIZEDVIEWS.INITRANS} INITRANS {}
  {9i.MATERIALIZEDVIEWS.MAXTRANS} MAXTRANS {}
  {9i.MATERIALIZEDVIEWS.PCTFREE} PCTFREE {}
  {9i.MATERIALIZEDVIEWS.PCTUSED} PCTUSED {}

ORACLE MATERIALIZED_VIEW {Storage Space}
  {9i.MATERIALIZEDVIEWS.BUFFERPOOL} BUFFER_POOL {}
  {9i.MATERIALIZEDVIEWS.FREELISTGROUPS} FREELISTGROUPS {}
  {9i.MATERIALIZEDVIEWS.FREELISTS} FREELISTS {}
  {9i.MATERIALIZEDVIEWS.INITIAL} INITIAL {}
  {9i.MATERIALIZEDVIEWS.MAXEXTENTS} MAXEXTENTS {}
  {9i.MATERIALIZEDVIEWS.MINEXTENTS} MINEXTENTS {}
  {9i.MATERIALIZEDVIEWS.PCTINCREASE} PCTINCREASE {}
  {Next} NEXT {}
  {Tablespace} TABLESPACE {}

ORACLE MATERIALIZED_VIEW {}
  {Generation Comments} GENERATION_COMMENTS {}

ORACLE NESTED_TABLE {Identification}
  {Deployable} DEPLOYABLE {true}

ORACLE NESTED_TABLE {}
  {Generation Comments} GENERATION_COMMENTS {}

ORACLE OBJECT_TYPE {IDENTIFICATION}
  {Deployable} DEPLOYABLE {true}

ORACLE OBJECT_TYPE {}
  {Generation Comments} GENERATION_COMMENTS {}

ORACLE ORACLE_MODULE {Identification}
  {Deployable} DEPLOYABLE {true}
  {Application Short Name} APPLICATION_SHORT_NAME {WB}
  {Main Application Short Name} MAIN_APPLICATION_SHORT_NAME {ora}
  {Top Directory} TOP_DIRECTORY {..\..\codegen\}

ORACLE ORACLE_MODULE {Deployment System Type}
  {PL/SQL Generation Mode} PLSQL_GENERATION_MODE {Default}

ORACLE ORACLE_MODULE {Generation Preferences}
  {End of Line} END_OF_LINE {\r\n}

ORACLE ORACLE_MODULE {Generation Target Directories}
  {8i.ORACLE8.1.SQLPLUSDIRECTORY} SQLPLUS_DIRECTORY {sqlplus\}
  {8i.ORACLE8.1.SQLPLUSEXTENSION} SQLPLUS_EXTENSION {.sql}
  {8i.ORACLE8.1.SQLPLUSRUNPRM} SQLPLUS_RUN_PARAMETER_FILE {_run.ini}
  {8i.ORACLE8.1.ZDTTDFEXTENSION} ZDT_EXTENSION {.tdf}
  {ABAP Extension} ABAP_EXTENSION {.abap}
  {ABAP Run Parameter File} ABAP_RUN_PARAMETER_FILE {_run.ini}
  {ABAP Spool Directory} ABAP_SPOOL_DIRECTORY {abap\log\}
  {DDL Directory} DDL_DIRECTORY {ddl\}
  {DDL Extension} DDL_EXTENSION {.ddl}
  {DDL Spool Directory} DDL_SPOOL_DIRECTORY {ddl\log\}
  {LIB Directory} LIB_DIRECTORY {lib\}
  {LIB Extension} LIB_EXTENSION {.lib}
  {LIB Spool Directory} LIB_SPOOL_DIRECTORY {lib\log\}
  {LOADER Directory} LOADER_DIRECTORY {ctl\}
  {LOADER Extension} LOADER_EXTENSION {.ctl}
  {LOADER Run Parameter File} LOADER_RUN_PARAMETER_FILE {_run.ini}
  {PL/SQL Directory} PLSQL_DIRECTORY {pls\}
  {PL/SQL Extension} PLSQL_EXTENSION {.pls}
  {PL/SQL Run Parameter File} PLSQL_RUN_PARAMETER_FILE {_run.ini}
  {PL/SQL Spool Directory} PLSQL_SPOOL_DIRECTORY {pls\log\}
  {Staging File Directory} ABAP_DIRECTORY {abap\}
  {TCL Directory} TCL_DIRECTORY {tcl\}

ORACLE ORACLE_MODULE {Run Time Directories}
  {Archive Directory} ARCHIVE_DIRECTORY {archive\}
  {Input Directory} INPUT_DIRECTORY {input\}
  {Invalid Directory} INVALID_DIRECTORY {invalid\}
  {Log Directory} LOG_DIRECTORY {log\}
  {Receive Directory} RECEIVE_DIRECTORY {receive\}
  {Sort Directory} SORT_DIRECTORY {sort\}
  {Work Directory} WORK_DIRECTORY {work\}

ORACLE ORACLE_MODULE {Tablespace Defaults}
  {Default Index Tablespace} DEFAULT_INDEX_TABLESPACE {}
  {Default Object Tablespace} DEFAULT_OBJECT_TABLESPACE {}

ORACLE PACKAGE {Identification}
  {Deployable} DEPLOYABLE {true}

ORACLE PACKAGE {Options}
  {AUTHID} AUTHID {}

ORACLE PACKAGE {}
  {Generation Comments} GENERATION_COMMENTS {}

ORACLE PLSQL_RECORD_TYPE {}
  {Generation Comments} GENERATION_COMMENTS {}

ORACLE PROCEDURE {Identification}
  {Deployable} DEPLOYABLE {true}

ORACLE PROCEDURE {Options}
  {AUTHID} AUTHID {}
  {Deterministic} IS_DETERMINISTIC {}
  {Parallel Enable} IS_PARALLEL_ENABLE {}
  {Pragma Autonomous Transaction} PRAGMA_AUTONOMOUS_TRANSACTION {}

ORACLE PROCEDURE {}
  {Generation Comments} GENERATION_COMMENTS {}

ORACLE QUEUE_PROPAGATION {Generation Options}
  {Generate Database Link} GENERATE_DBLINK {true}
  {Generate Queue Propagation} GENERATE_QUEUE_PROPAGATION {true}
  {Generate Ruleset and Rule for Replication } GENERATE_REPLICATION_RULE {false}
  {Generate Schedule Propagation} GENERATE_SCHEDULE_PROPAGATION {true}

ORACLE QUEUE_PROPAGATION {Replication Option (Only for Streams queues)}
  {Not Permitted Tag Values} NOT_PERMITTED_TAG_VALUES {}
  {Permitted Tag Values} PERMITTED_TAG_VALUES {}

ORACLE QUEUE_PROPAGATION {Scheduling Options}
  {Duration} DURATION {}
  {Latency} LATENCY {60}
  {Next Time} NEXT_TIME {}
  {Start Time} START_TIME {SYSDATE}

ORACLE QUEUE_PROPAGATION {}
  {Deployable} DEPLOYABLE {true}
  {Transformation} SUBCRIBER_TRANSFORMATION {}
  {Generation Comments} GENERATION_COMMENTS {}
  {Rule Condition} SUBSCRIBER_RULE_CONDITION {}

ORACLE QUEUE_TABLE {Generation Options}
  {Generate Queue Table} GENERATE_QUEUE_TABLE {true}

ORACLE QUEUE_TABLE {Storage Space}
  {Tablespace} TABLESPACE {}

ORACLE QUEUE_TABLE {}
  {Deployable} DEPLOYABLE {true}
  {Generation Comments} GENERATION_COMMENTS {}

ORACLE SEQUENCE {Identification}
  {Deployable} DEPLOYABLE {true}

ORACLE SEQUENCE {Sequence Parameters}
  {Increment By} INCREMENT_BY {1}
  {Start With} START_WITH {1}

ORACLE SEQUENCE {}
  {Generation Comments} GENERATION_COMMENTS {}

ORACLE TABLE {Identification}
  {Deployable} DEPLOYABLE {true}
  {Error Table Only} GENERATE_ERROR_TABLE_ONLY {false}

ORACLE TABLE {Parallel}
  {Parallel Access Mode} PARALLEL_ACCESS_MODE {}
  {Parallel Degree} PARALLEL_DEGREE {}

ORACLE TABLE {Change Data Capture}
  {Enable} IS_CDC {false}
  {Table Position} CDC_POSITION {0}

ORACLE TABLE {Error Table}
  {Tablespace} ERROR_TABLESPACE {}
  {Error Table Name } ERROR_TABLE_NAME {}

ORACLE TABLE {Partition Parameters}
  {Overflow Tablespace List} OVERFLOW {}
  {Partition Tablespace List} PARTITION_TABLESPACE_LIST {}

ORACLE TABLE {Performance Parameters}
  {Buffer Cache} CACHE_MODE {}
  {Data Segment Compression} DATA_SEGMENT_COMPRESSION {}
  {Estimate Percent To Analyze Table} ANALYZE_TABLE_ESTIMATE_PERCENT {}
  {Logging Mode} LOGGING_MODE {}
  {Row Movement} ROW_MOVEMENT {}
  {Row-level Dependency} ROWDEPENDENCIES_MODE {}
  {Statistics Collection} MONITORING_MODE {}

ORACLE TABLE {Physical Attributes}
  {INITRANS} INITRANS {}
  {MAXTRANS} MAXTRANS {}
  {PCTFREE} PCTFREE {}
  {PCTUSED} PCTUSED {}

ORACLE TABLE {Storage Space}
  {BUFFER_POOL} BUFFER_POOL {}
  {FREELISTS} FREELISTS {}
  {INITIAL} INITIAL {}
  {MAXEXTENTS} MAXEXTENTS {}
  {MINEXTENTS} MINEXTENTS {}
  {NEXT} NEXT {}
  {PCTINCREASE} PCTINCREASE {}
  {Tablespace} TABLESPACE {}
  {FREELIST GROUPS} FREELISTGROUPS {}

ORACLE TABLE {}
  {Generation Comments} GENERATION_COMMENTS {}

ORACLE TABLE_FUNCTION {Identification}
  {Deployable} DEPLOYABLE {true}

ORACLE TABLE_FUNCTION {Options}
  {AUTHID} AUTHID {}
  {Deterministic} IS_DETERMINISTIC {}
  {Parallel Enable} IS_PARALLEL_ENABLE {}
  {Pragma Autonomous Transaction} PRAGMA_AUTONOMOUS_TRANSACTION {}

ORACLE TABLE_FUNCTION {}
  {Generation Comments} GENERATION_COMMENTS {}

ORACLE TYPED_QUEUE {Generation Options}
  {9i.ADVANCEDQUEUES.GENERATEAQ} GENERATE_ADVANCED_QUEUE {true}
  {9i.ADVANCEDQUEUES.GENERATETEMPTABLE} GENERATE_TEMPORARY_TABLE {true}

ORACLE TYPED_QUEUE {}
  {9i.ADVANCEDQUEUES.DEFAULT.DEPLOYABLE} DEPLOYABLE {true}
  {9i.ADVANCEDQUEUES.DEFAULT.MAXRETRIES} MAX_RETRIES {5}
  {9i.ADVANCEDQUEUES.DEFAULT.RETENTIONTIME} RETENTION_TIME {0}
  {9i.ADVANCEDQUEUES.DEFAULT.RETRYDELAY} RETRY_DELAY {0}
  {Dequeue Enabled} DEQUEUE_ENABLED {true}
  {Enqueue Enabled} ENQUEUE_ENABLED {true}
  {Generation Comments} GENERATION_COMMENTS {}

ORACLE VARYING_ARRAY {Identification}
  {Deployable} DEPLOYABLE {true}

ORACLE VARYING_ARRAY {}
  {Generation Comments} GENERATION_COMMENTS {}

ORACLE VIEW {Identification}
  {Deployable} DEPLOYABLE {true}
  {Error Table Only} GENERATE_ERROR_TABLE_ONLY {false}

ORACLE VIEW {Error Table}
  {Tablespace} ERROR_TABLESPACE {}
  {Error Table Name } ERROR_TABLE_NAME {}

ORACLE VIEW {}
  {Generation Comments} GENERATION_COMMENTS {}

SQLSERVER FUNCTION {Identification}
  {Deployable} DEPLOYABLE {true}

SQLSERVER FUNCTION {Options}
  {Encryption} ENCRYPTION {}
  {Execute As} EXECUTE_AS {}
  {Schema Binding} SCHEMABINDING {}
  {With Null Input} WITH_NULL_INPUT {}

SQLSERVER FUNCTION {}
  {Generation Comments} GENERATION_COMMENTS {}

SQLSERVER SQLSERVER_MODULE {GENERATION_TARGET_DIRECTORIES}
  {8i.SQLSERVER.1.CTLDIRECTORY} LOADER_DIRECTORY {ctl\}
  {8i.SQLSERVER.1.CTLEXTENSION} LOADER_EXTENSION {.ctl}
  {8i.SQLSERVER.1.CTLRUNPRM} LOADER_RUN_PARAMETER_FILE {_run.ini}

SQLSERVER TABLE {Change Data Capture}
  {Enable} IS_CDC {false}
  {Table Position} CDC_POSITION {0}

propertyNameList

Comma separated list of property names. Property names are unquoted.

propertyValueList

Comma separated list of property values. Property values are quoted.

getType

The object type that contains the property. (See setTemplateValuesClause for possible values.)

propertyValue

The new value for the property.

See Also

OMBCREATE

OMBALTER CONFIGURATION_TEMPLATE

OMBDROP CONFIGURATION_TEMPLATE

Go to previous page
Previous		 Go to next page
Next
Go to Documentation Home
Home		 Go to Book List
Book List		 Go to Table of Contents
Contents		 Go to Master Index
Master Index		 Go to Feedback page
Contact Us