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
 

OMBALTER FOLDER

Purpose

Alter the folder by renaming it, and/or reset its properties, and/or adding/removing contained objects..

Prerequisites

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

Syntax

alterUserFolderCommand =  OMBALTER ( FOLDER "QUOTED_STRING" ( [ 
          "renameClause" ] [ SET "setPropertiesClause" [ SET 
          "setReferenceIconSetClause" | UNSET "unsetReferenceIconSetClause" ] | 
          SET "setReferenceIconSetClause" | UNSET "unsetReferenceIconSetClause" 
          ] [ "alterContainedObjects" ] ) )
     renameClause =  RENAME TO "QUOTED_STRING"
     setPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     setReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET "QUOTED_STRING"
     unsetReferenceIconSetClause =  ( REFERENCE | REF ) ICONSET
     alterContainedObjects =  ( "addContainedObjClause" | 
          "removeContainedObjClause" )+
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     addContainedObjClause =  ADD CONTAINED_OBJECT "containedObjTypeClause" 
          "QUOTED_STRING"
     removeContainedObjClause =  REMOVE CONTAINED_OBJECT 
          "containedObjTypeClause" "QUOTED_STRING"
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )
     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 )

Parameters

alterUserFolderCommand

This command modifies an existing folder.

QUOTED_STRING

Name of the existing folder in single quotes.

renameClause

Rename a folder.

setPropertiesClause

Associate a set of properties with the existing 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.

unsetReferenceIconSetClause

Unset icon set for the folder.

alterContainedObjects

Adds or removes a contained object to/from the folder.

propertyNameList

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

propertyValueList

Comma separated list of property values.

addContainedObjClause

Adds a contained object to the folder.

removeContainedObjClause

Removes a contained object from the folder.

propertyValue

Value of a property.

containedObjTypeClause

The type of the contained object to be added or removed. 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.