OMBALTER EXTERNAL_TABLE

Purpose

Alter the external table by renaming it, and/or reset its properties.

Prerequisites

Should be in the context of an Oracle Module.

Syntax

alterExternalTableCommand =  OMBALTER ( EXTERNAL_TABLE "QUOTED_STRING" ( 
          "renameClause" [ "alterExternalTablePropertiesAndReferencesClause" ] [
           "alterExternalTableObjectClauses" ] | 
          "alterExternalTablePropertiesAndReferencesClause" [ 
          "alterExternalTableObjectClauses" ] | 
          "alterExternalTableObjectClauses" ) )
     renameClause =  RENAME TO "QUOTED_STRING"
     alterExternalTablePropertiesAndReferencesClause =  SET ( 
          "setPropertiesClause" [ SET ( REF | REFERENCE ) 
          "alterReferencesToRecordAndLocationClauses" | UNSET ( REF | REFERENCE 
          ) "unsetReferenceIconSetClause" ] | ( REF | REFERENCE ) 
          "alterReferencesToRecordAndLocationClauses" ) | UNSET ( REF | 
          REFERENCE ) "unsetReferenceIconSetClause"
     alterExternalTableObjectClauses =  ADD ( "addExternalTableObjectClause" [ 
          "alterExternalTableObjectClauses" ] | "addDataRuleUsageClause" { 
          "alterDataRuleUsageClauses" } ) | MODIFY ( 
          "modifyExternalTableObjectClause" [ "alterExternalTableObjectClauses" 
          ] | "addDataRuleUsageClause" { "alterDataRuleUsageClauses" } ) | 
          DELETE ( "deleteExternalTableObjectClause" [ 
          "alterExternalTableObjectClauses" ] | "deleteDataRuleUsageClause" { 
          "alterDataRuleUsageClauses" } )
     setPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     alterReferencesToRecordAndLocationClauses =  
          "setReferencesToRecordFileModuleClause" [ 
          "setReferencesToLocationClause" ] [ SET ( REF | REFERENCE ) 
          "setReferenceIconSetClause" | UNSET ( REF | REFERENCE ) 
          "unsetReferenceIconSetClause" ] | "setReferencesToFileAndModuleClause"
           [ "setReferencesToLocationClause" ] [ SET ( REF | REFERENCE ) 
          "setReferenceIconSetClause" | UNSET ( REF | REFERENCE ) 
          "unsetReferenceIconSetClause" ] | "setReferencesToLocationClause" [ 
          SET ( REF | REFERENCE ) "setReferenceIconSetClause" | UNSET ( REF | 
          REFERENCE ) "unsetReferenceIconSetClause" ] | 
          "setReferenceIconSetClause"
     unsetReferenceIconSetClause =  ICONSET
     addExternalTableObjectClause =  COLUMN "QUOTED_STRING" [ AT POSITION 
          "INTEGER_LITERAL" ] [ SET "setPropertiesAndReferencesToFieldClauses" ]
           | "addExternalTableDatafileClause"
     addDataRuleUsageClause =  DATA_RULE_USAGE "QUOTED_STRING" SET REF DATA_RULE
           "QUOTED_STRING" ( GROUP "QUOTED_STRING" SET REF ( TABLE | VIEW | 
          MATERIALIZED_VIEW | EXTERNAL_TABLE ) "QUOTED_STRING" ( ATTRIBUTE 
          "QUOTED_STRING" SET REF COLUMN "QUOTED_STRING" )+ )+ [ SET 
          "setPropertiesClause" ]
     alterDataRuleUsageClauses =  ADD "addDataRuleUsageClause" | MODIFY 
          "modifyDataRuleUsageClause" | DELETE "deleteDataRuleUsageClause"
     modifyExternalTableObjectClause =  COLUMN "QUOTED_STRING" ( "renameClause" 
          [ "moveExternalTableColumnToClause" ] [ SET 
          "setPropertiesAndReferencesToFieldClauses" ] | 
          "moveExternalTableColumnToClause" [ SET 
          "setPropertiesAndReferencesToFieldClauses" ] | SET 
          "setPropertiesAndReferencesToFieldClauses" ) | DATA_FILE 
          "QUOTED_STRING" ( "renameClause" [ SET "setPropertiesClause" ] | SET 
          "setPropertiesClause" )
     deleteExternalTableObjectClause =  COLUMN "QUOTED_STRING" | DATA_FILE 
          "QUOTED_STRING"
     deleteDataRuleUsageClause =  DATA_RULE_USAGE "QUOTED_STRING"
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     setReferencesToRecordFileModuleClause =  RECORD "QUOTED_STRING" OF 
          FLAT_FILE "QUOTED_STRING"
     setReferencesToLocationClause =  DEFAULT_LOCATION "QUOTED_STRING"
     setReferenceIconSetClause =  ICONSET "QUOTED_STRING"
     setReferencesToFileAndModuleClause =  FLAT_FILE "QUOTED_STRING"
     setPropertiesAndReferencesToFieldClauses =  "setPropertiesClause" [ SET ( 
          REF | REFERENCE ) "setReferencesToFieldClause" ] | ( REF | REFERENCE )
           "setReferencesToFieldClause"
     addExternalTableDatafileClause =  DATA_FILE "QUOTED_STRING" [ SET 
          "setPropertiesClause" ]
     modifyDataRuleUsageClause =  DATA_RULE_USAGE "QUOTED_STRING" ( 
          "renameClause" [ SET "setPropertiesClause" ] | SET 
          "setPropertiesClause" )
     moveExternalTableColumnToClause =  MOVE TO POSITION "INTEGER_LITERAL"
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )
     setReferencesToFieldClause =  FIELD "QUOTED_STRING"

Parameters

Basic properties for COLUMN: 

Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Business name of the column

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

Name: DATATYPE
Type: STRING
Valid Values: BINARY_DOUBLE, BINARY_FLOAT, BLOB, CHAR, CLOB, DATE, FLOAT, INTEGER, INTERVAL DAY TO SECOND, INTERVAL YEAR TO MONTH, NCHAR, NCLOB, NUMBER, NVARCHAR2, RAW, TIMESTAMP, TIMESTAMP WITH LOCAL TIME ZONE, TIMESTAMP WITH TIME ZONE, VARHCAR, VARCHAR2
Default: NUMBER
The datatype of a column

Name: LENGTH
Type: NUMBER
Valid Values: 
Default: 1
The length of a number 

Name: PRECISION
Type: NUMBER
Valid Values: 0 - 38
Default: 1
The precision of a number. Use 0 to specify floating-point numbers.

Name: SCALE
Type: NUMBER
Valid Values: -84 - 127
Default: 1
The scale of a number.

Name: FRACTIONAL_SECONDS_PRECISION
Type: NUMBER
Valid Values: 0 - 9
Default: 0
The precision of a timestamp or interval.

See Also

OMBALTER

OMBCREATE EXTERNAL_TABLE

OMBDROP EXTERNAL_TABLE

OMBRETRIEVE EXTERNAL_TABLE