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
Mobi · ePub

OMBCREATE FOLDER

Purpose

To create a folder.

Prerequisites

Should be in the context of a module (Oracle, Non-Oracle, Aplications, Process Flow types) or a folder.

Syntax

createUserFolderCommand =  OMBCREATE ( FOLDER "QUOTED_STRING" [ SET 
          "setPropertiesClause" [ SET "setReferenceIconSetClause" ] | SET 
          "setReferenceIconSetClause" ] ( { "addContainedObjClause" } ) )
     setPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     setReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET "QUOTED_STRING"
     addContainedObjClause =  ADD CONTAINED_OBJECT "containedObjTypeClause" 
          "QUOTED_STRING"
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     containedObjTypeClause =  ( TABLE | VIEW | PACKAGE | DIMENSION | 
          MATERIALIZED_VIEW | SEQUENCE | CUBE | DATA_AUDITOR | ADVANCED_QUEUE | 
          QUEUE_TABLE | EXTERNAL_TABLE | VARYING_ARRAY | OBJECT_TYPE | 
          NESTED_TABLE | MAPPING | PLUGGABLE_MAPPING | PROCESS_FLOW_PACKAGE | 
          FUNCTION | TABLE_FUNCTION | PROCEDURE )
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

createUserFolderCommand

This command creates a folder

QUOTED_STRING

Name of the folder to be created.

setPropertiesClause

Associate a set of properties with a folder.

propertiesClause

Basic properties for FOLDER:

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

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

setReferenceIconSetClause

Set icon set for the folder module.

addContainedObjClause

This command adds a module object to the folder as a contained object.

propertyNameList

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

propertyValueList

Comma separated list of property values.

containedObjTypeClause

The type of the contained object to be added. Valid object types are: TABLE | VIEW | PACKAGE | DIMENSION | MATERIALIZED_VIEW | SEQUENCE | CUBE | ADVANCED_QUEUE | STREAMS_QUEUE | QUEUE_TABLE | EXTERNAL_TABLE | VARYING_ARRAY | OBJECT_TYPE | NESTED_TABLE | MAPPING | PROCESS_FLOW_PACKAGE | FUNCTION | PROCEDURE.

propertyValue

Value of a property.