alter table 錳И(prototype)
ALTER TABLE 僥曖 prototype(錳И)擎棻擠婁偽棻.
□И衝■

ALTER TABLE [schema.]table
[{alter_table_properties       ¦
  column_clauses               ¦
  constraint_clause            ¦
  alter_table_partitioning     ¦
  alter_external_table_clauses ¦
  move_table_clause } ]
[{{enable_disable_clause} ¦
  {{ENABLE ¦ DISABLE} 
   {TABLE LOCK ¦ ALL TRIGGERS} }...  } ];



□alter_table_propertiesИ衝■
  {{{{physical_attributes_clause    ¦
      logging_clause                ¦
      table_compression             ¦
      supplemental_table_logging    ¦
      allocate_extent_clause        ¦
      deallocate_unused_clause      ¦
      {CACHE ¦ NOCACHE}             ¦
      update_table_clause           ¦
      records_per_block_clause      ¦
      parallel_clause               ¦
      row_movement_clause           ¦
      flashback_archive_clasue}...} ¦
    RENAME TO new_table_name} 
   [alter_iot_clauses] 
   [alter_XMLSchema_clause]} ¦
  shrink_clause              ¦
  READ ONLY                  ¦
  READ WRITE                 ¦
  REKEY encryption_spec 

□physical_attributes_clauseИ衝■
   [{PCTFREE integer ¦
     PCTUSED integer ¦
     INITRANS integer ¦
     storage_clause}...]

□logging_clauseИ衝■
   LOGGING ¦
   NOLOGGING ¦
   FILESYSTEM_LIKE_LOGGING

□table_compressionИ衝■
   {COMPRESS [FOR{ALL ¦ DIRECT_LOAD} OPERATIONS]} ¦
    NOCOMPRESS

□supplemental_table_loggingИ衝■
   {ADD {SUPPLEMENTAL LOG {supplemental_log_grp_clause ¦
                           supplemental_id_key_clause},...}} ¦
   {DROP {SUPPLEMENTAL LOG {supplemental_id_key_clause ¦
                            GROUP log_group},...}}

□supplemental_log_grp_clauseИ衝■
   GROUP log_group ({column [no log]},...) 
    [ALWAYS]

□supplemental_id_key_clauseИ衝■
   DATA ({ALL ¦
          PRIMARY KEY ¦
          UNIQUE ¦
          FOREIGN KEY},...) COLUMNS

□allocate_extent_clauseИ衝■
   ALLOCATE EXTENT 
    [({SIZE size_clause ¦
       DATAFILE 'filename' ¦
       INSTANCE integer}...)]

□deallocate_unused_clauseИ衝■
   DEALLOCATE UNUSED
   [KEEP size_clause]

□shrink_clauseИ衝■
   SHRINK SPACE 
   [COMPACT] 
   [CASCADE]

□upgrade_table_clauseИ衝■
   UPGRADE [[NOT] INCLUDING DATA] 
           [column_properties]

□records_per_block_clauseИ衝■
   {MINIMIZE ¦ NOMINIMIZE} RECORDS_PER_BLOCK

□parallel_clauseИ衝■
   {NOPARALLEL ¦ {PARALLEL [integer]}}

□row_movement_clauseИ衝■
   {ENABLE ¦ DISABLE} ROW MOVEMENT

□alter_iot_clausesИ衝■
   index_org_table_clause      ¦
   alter_overflow_clause       ¦
   alter_mapping_table_clauses ¦
   COALESCE
 
□index_org_table_clauseИ衝■
   [{mapping_table_clause ¦
     PCTTHRESHOLD integer ¦
     key_compression}...]
   [integer_org_overflow_clause]

□mapping_table_clauseИ衝■
   {MAPPING TABLE] ¦ NOMAPPING

□key_compressionИ衝■
   {COMPRESS [integer]} ¦ NOCOMPRESS
 
□index_org_overflow_clauseИ衝■
   [INCLUDING column_name]
   OVERFLOW 
   [segment_attributes_clause]

□partition_extended_nameИ衝■
   {PARTITION partition} ¦
   {PARTITION FOR ( partition_key_value,...)}

□substitution_extended_nameИ衝■
   {SUBPARTITION subpartition} ¦
   {SUBPARTITION FOR ( subpartition_key_value,...)}

□segment_attributes_clauseИ衝■
   {physical_attributes_clauses ¦
    {TABLESPACE tablespace} ¦
    logging_clause}
  
□alter_overflow_clausesИ衝■ 
   alter_overflow_clause ¦
   {OVERFLOW {segment_attributes_clause ¦
              allocate_extent_clause    ¦
              shrink_clause             ¦
              deallocate_unused_clause}...}

□add_overflow_clauseИ衝■
   ADD OVERFLOW 
   [segment_attributes_clause]
   [({PARTITION [segment_attributes_clause]},...)] 

□alter_mapping_table_clausesИ衝■
   MAPPING TABLE {allocate_extent_clause ¦
                  deallocate_unused_clause}

□column_clausesИ衝■
   {add_column_clauses    ¦ 
    modify_column_clauses ¦
    drop_column_clauses}...      ¦
   rename_column_clause          ¦
   modify_collection_retrival... ¦
   modify_LOB_storage_clause     ¦
   alter_varray_col_properties...

□add_column_clauseИ衝■
   ADD {{column_definition ¦ virtual_column_definition},...})
   [column_properties

□column_definitionИ衝■
   column datatype 
   [SORT] 
   [DEFAULT expr] 
   [ENCRYPT encryption_spec]
   [{inline_constraint... ¦
     inline_ref_constraint}]

□virtual_column_definitionИ衝■
   column [datatype] 
          [GENERATED ALWAYS]
   AS (column_expression)
          [VIRTUAL]
          [inline_constraint...]

□modify_column_clauseИ衝■
   MODIFY {(modify_col_properties,...) ¦
           modify_col_substitutable}

□modify_col_propertiesИ衝■
   column 
   [datatype]
   [DEFAULT expr]
   [{ENCRYPT encryption_spec} ¦ DESCRIPT]
   [inline_constraint...]
   [LOB_storage_clause]
   [alter_XMLSchema_clause]

□encryption_specИ衝■
   [USING 'encrypt_algorithm']
   [IDENTIFIED BY password]
   [[NO] SALT]

□modify_col_substitutableИ衝■
   COLUMN column [NOT] SUBSTITUTABLE AT ALL LEVELS [FORCE]

□drop_column_clauseИ衝■
   {SET UNUSED {{COLUMN column} ¦ (column,...)}
    [{CASCADE CONSTRAINTS ¦ INVALIDATE}]       } ¦
   {DROP {{COLUMN column} ¦ (column,...)}
    [{CASCADE CONSTRAINTS ¦ INVALIDATE}]
    [CHECKPOINT integer]                            } ¦
   {DROP {{UNUSED COLUMNS} ¦ {COLUMNS CONTINUE}}
    [CHECKPOINT integer]                            }

□rename_column_clauseИ衝■
   RENAME COLUMN old_name TO new_name


□modify_collection_retrievalИ衝■
   MODIFY NESTED TABLE collection_item 
   RETURN AS {LOCATOR ¦ VALUE}

□constraint_clausesИ衝■
   {ADD {out_of_line_constraint... ¦ out_of_ref_constraint}  } ¦
   {MODIFY {CONSTRAINT constraint } ¦
           {PRIMARY KEY}            ¦
           {UNIQUE (column...)} constraint_state                  } ¦
   {RENAME CONSTRAINT old_name TO new_name                        } ¦
   {drop_constraint_clause}

□drop_constraint_clauseИ衝■
   DROP {{{PRIMARY KEY} ¦ {UNIQUE (column,...)}
          [CASCADE] [{DROP ¦ KEEP} INDEX]           } ¦
        {CONSTRAINT constraint [CASCADE]}

□column_propertiesИ衝■
   {{object_type_col_prptotypes}  ¦
    {nested_table_col_properties} ¦
    {{varray_col_properties ¦ LOB_storage_clause}
     [(LOB_partition_storage,...)]} ¦
    {XMLType_column_properties
   }...

□object_type_of_propertiesИ衝■
   COLUMN column substitutable_column_clause

□substitutable_column_clauseИ衝■
   {[ELEMENT] IS OF [TYPE] (ONLY type)} ¦
   {[NOT] SUBSTITUTABLE AT ALL LEVELS}

□nested_table_col_propertiesИ衝■
   NESTED TABLE {nested_item ¦ COLUMN_VALUE}
    [substitutable_column_clause]
   STORE AS storage_table
    [({(object_properties) ¦
       physical_properties ¦
       column_properties}...)]
    [RETURN AS {LOCATOR ¦ VALUE}] 

□object_propertiesИ衝■
   {{column ¦ attribute} [DEFAULT expr] [inline_constraint... ¦ inline_ref_constraint} ¦
   {{out_of_line_constraint} ¦
    {out_of_line_ref_constraint} ¦
    {supplemental_logging_props}}

□supplemental_logging_propsИ衝■
   SUPPLEMENTAL LOG {supplemental_log_grp_clause ¦
                     supplemental_id_key_clause}

□physical_propertiesИ衝■
   {segment_attribute_clause [table_compression]} ¦
   {ORGANIZATION {HEAP [segment_attribute_clause] [table_compression]} ¦
                 {INDEX [segment_attribute_clause] index_org_table_clause} ¦
                 {EXTERNAL external_table_clause}} ¦
   {CLUSTER cluster (column,...)}

□varray_col_propertiesИ衝■
   VARRAY varray_item
     {[substitutable_column_clause] varray_storage_clasue} ¦
     {substitutable_column_clause}

□varray_storage_clauseИ衝■
   STORE AS [SECUREFILE ¦ BASICFILE] 
   LOB {{[LOB_segname] (LOB_storage_parameters)} ¦ LOB_segname} 

□LOB_storage_clauseИ衝■
   LOB {{(LOB_item,...) STORE AS 
         {SECUREFILE ¦
          BASICFILE  ¦
          (LOB_storage_parameters)}... } ¦
        {(LOB_item) STORE AS
         {SECUREFILE ¦
          BASICFILE  ¦
          LOB_segname ¦
          (LOB_storage_parameters)}... }

□LOB_storage_parametersИ衝■
   {{TABLESPACE tablespace ¦ 
    {LOB_parameters [storage_clause]}...} ¦
   storage_clause
    
□LOB_parametersИ衝■
   {{{ENABLE ¦ DISABLE} STORAGE IN ROW}      ¦
    {CHUNK integer}                          ¦
    {PCTVERSION integer}                     ¦
    {FREEPOOLS integer}                      ¦
    {LOB_retention_clause}                   ¦
    {LOB_duplicate_clause}                   ¦
    {LOB_compression_clause}                 ¦
    {{ENCRYPT encryption_spec} ¦ DECRYPT}    ¦
    {CACHE ¦ {{NOCACHE ¦ CACHE READS} [logging_clause]}
   }...

□modify_LOB_storage_clauseИ衝■
   MODIFY LOB (LOB_item) (modify_LOB_parameters)

□modify_LOB_parametersИ衝■
   {{storage_clause                          ¦
    {PCTVERSION ¦ FREEPOOLS integer}         ¦
    {REBUILD FREEPOOLS                       ¦
    {LOB_retention_clause}                   ¦
    {LOB_duplicate_clause}                   ¦
    {LOB_compression_clause}                 ¦
    {{ENCRYPT encryption_spec} ¦ DECRYPT}    ¦
    {CACHE ¦ {{NOCACHE ¦ CACHE READS} [logging_clause]} ¦
    {allocate_extent_clause}                 ¦
    {shrink_clause}                          ¦
    {deallocate_unused_clause}
   }...

□LOB_retention_clauseИ衝■
   RETENTION [MAX        ¦
              MIN nteger ¦
              AUTO       ¦
              NONE] 

□LOB_deduplicate_clauseИ衝■
   DEDUPLICATE ¦ KEEP_DUPLICATES

□LOB_compression_clauseИ衝■
   {COMPRESS [HIGH ¦ MEDIUM]} ¦
   NOCOMPRESS

□alter_varray_col_propertiesИ衝■
   MODIFY VARRAY varray_item (modify_LOB_parameters)

□LOB_partition_storageИ衝■
   PARTITION partition {LOB_storage_clause ¦ varray_col_properties}...
   [(SUBPARTITION subpartition {LOB_partitioning_storage ¦
                                varray_col_properties})]

□LOB_partitioning_storageИ衝■
   LOB (LOB_item) STORE AS
   [SECUREFILE ¦ BASICFILE]
   [{LOB_segname [(TABLESPACE tablespace)]} ¦
    {(TABLESPACE tablespace)}]

□XMLType_column_propertiesИ衝■
   XMLTYPE [COLUMN] column [XMLType] [XMLSchema_spec]

□XMLType_storageИ衝■
   STORE AS
    {{OBJECT RELATIONAL} ¦
     {[SECUREFILE ¦ BASICFILE]
      {CLOB ¦ {BINARY XML}}
      [{LOB_segname [(LOB_parameters)]} ¦ {(LOB_parameters)}]

□XMLSchema_specИ衝■
   {single_XMLSchema_spec ¦ multiple_XMLSchema_spec}
    [{ALLOW {ANYSCHEMA ¦ NONSCHEMA}} ¦
     {DISALLOW NONSCHEMA}]

□single_XMLSchema_specИ衝■
   [XMLSCHEMA XMLSchema_URL] ELEMENT {element ¦
                                      {XMLSchema_URL # element}}

□multiple_XMLSchema_specИ衝■
   XMLSCHEMAS (single_XMLSchema_spec,...)

□alter_XMLSchema_clauseИ衝■
   {ADD ¦ REMOVE} multiple_XMLSchema_spec 
    [{ALLOW {ANYSCHEMA ¦ NONSCHEMA}} ¦
     {DISALLOW NONSCHEMA}]

□alter_external_tableИ衝■
   {add_column_clause ¦
    modify_column_clause ¦
    drop_column_clause ¦
    parallel_clause ¦
    external_data_properties ¦
    REJECT LIMIT {integer ¦ UNLIMITED} ¦
    PROJECT COLUMN {ALL ¦ REFERENCED}
   }...

□external_data_propertiesИ衝■
   DEFAULT DIRECTORY directory
   [ACCESS PARAMETERS {(opaque_format_spec) ¦
                       {USING CLOB subquery}}]
   LOCATION ({[directory:] 'location_specifier'},...)

□alter_table_partitioningИ衝■
   modify_table_default_attrs      ¦
   alter_interval_partitioning     ¦
   set_subpartition_template       ¦
   modify_table_partition          ¦
   modify_table_subpartition       ¦
   move_table_partition            ¦
   move_table_subpartition         ¦
   add_table_partition             ¦
   coalesce_table_partition        ¦
   coalesce_table_subpartition     ¦
   drop_table_partition            ¦
   drop_table_subpartition         ¦
   rename_partition_subpart        ¦
   truncate_partition_subpart      ¦
   split_table_partition           ¦
   split_table_subpartition        ¦
   merge_table_partition           ¦
   merge_table_subpartition        ¦
   exchange_partition_subpart
   
□modify_table_default_attrsИ衝■
   MODIFY DEFAULT ATTRIBUTES 
   [FOR partition_extended_name]
   [segment_attributes_clause]
   [table_compression]
   [PCTTHRESHOLD integer]
   [key_compression]
   [alter_overflow_clause]
   [{{LOB (LOB_item)} ¦ {VARRAY varray}} (LOB_parameters)}...]

□alter_interval_partitioningИ衝■
   {SET INTERVAL (expr)} ¦
   {SET SET STORE IN (tablespace,...)}

□set_subpartition_templateИ衝■
   SET SUBPARTITION TEMPLATE
   {{(range_subpartition_desc,... ¦ list_subpartition_desc,...)} ¦
    hash_subpartition_quantity}

□modify_table_partitionИ衝■
   modify_range_partition     ¦
   modify_hash_partition      ¦
   modify_list_partition
 
□modify_range_partitionИ衝■
   MODIFY partition_extended_name
    {partition_attributes                                           ¦
     add_range_subpartition                                         ¦
     add_hash_subpartition                                          ¦
     add_list_subpartition                                          ¦
     COALESCE SUBPARTITION [update_index_clauses] [parallel_clause] ¦
     alter_mapping_table_clause                                     ¦
     [REBUILD] UNUSABLE LOCAL INDEXES
    }

□modify_hash_partitionИ衝■
   MODIFY partition_extended_name 
    {partition_attributes           ¦
     alter_mapping_table_clause     ¦
     [REBUILD] UNUSABLE LOCAL INDEXES
    }
 
□modify_list_partitionИ衝■
   MODIFY partition_extended_name
    {partition_attributes                                           ¦
     {ADD ¦ DROP} VALUES (literal,...)                              ¦
     add_range_subpartition                                         ¦
     add_hash_subpartition                                          ¦
     add_list_subpartition                                          ¦
     COALESCE SUBPARTITION [update_index_clauses] [parallel_clause] ¦
     [REBUILD] UNUSABLE LOCAL INDEXES
    }
     
□modify_table_subpartitionИ衝■
   MODIFY subpartition_extended_name
    {allocate_extent_clause                                               ¦
     deallocate_unused_clause                                             ¦
     shrink_clause                                                        ¦
     {{{LOB LOB_item} ¦ {VARRAY varray}} (modify_LOB_parameters)}...      ¦
     [REBUILD] UNUSABLE LOCAL INDEXES                                     ¦
     {ADD ¦ DROP} VALUES (literal,...)}
     
□move_table_partitionИ衝■
   MOVE partition_extended_name 
   [MAPPING TABLE]
   [table_partition_description]
   [update_index_clauses]
   [parallel_clause]

□move_table_subpartitionИ衝■
   MOVE {range_subpartition_desc ¦
         list_subpartition_desc  ¦
         hash_subpartition_desc}
   [update_index_clauses]
   [parallel_clause]
    
□add_table_partitionИ衝■
   ADD PARTITION [partition]
    {add_range_partition_clause   ¦
     add_hash_partition_clause    ¦
     add_list_partition_clause    ¦
     add_system_partition_clause}
    [dependent_table_clause] 

□add_range_partition_clauseИ衝■
   range_value_clause
   [table_partition_description]
   [({range_subpartition_desc  ¦
      list_subpartition_desc   ¦
      hash_subpartition_desc})]
   [update_index_clauses]

□add_hash_partition_clauseИ衝■
   partitioning_storage_clause
   [update_index_clauses]
   [parallel_clause]

□add_list_partition_clauseИ衝■
   list_value_clause
   [table_partition_description]
   [({range_subpartition_desc  ¦
      list_subpartition_desc   ¦
      hash_subpartition_desc})]
   [update_index_clauses]

□add_system_partition_clauseИ衝■
   [BEFORE {partition_name ¦ partition_number}]
   [table_partition_description]
   [update_index_clauses]
   
□add_range_subpartitionИ衝■
   ADD range_subpartition_desc
   [dependent_tables_clause]
   [update_index_clauses]

□add_hash_subpartitionИ衝■
   ADD hash_subpartition_desc
   [dependent_tables_clause]
   [update_index_clauses]
   [parallel_clause]

□add_list_subpartitionИ衝■
   ADD list_subpartition_desc
   [dependent_tables_clause]
   [update_index_clauses]

□dependent_table_clauseИ衝■
   DEPENDENT TABLES ({table (partition_spec,...)},...)

□coalesce_table_partitionИ衝■
   COALESCE PARTITION
   [update_index_clauses]
   [parallel_clause]

□coalesce_table_subpartitionИ衝■
   COALESCE SUBPARTITION subpartition
   [update_index_clauses]
   [parallel_clause]
 
□drop_table_partitionИ衝■
   DROP partition_extended_name
   [update_index_clauses [parallel_clause]]

□drop_table_subpartitionИ衝■
   DROP subpartition_extended_name
   [update_index_clauses [parallel_clause]]

□rename_partition_subpartИ衝■
   RENAME {partition_extended_name ¦ subpartition_exgtended_name}
   TO new_name

□truncate_partition_subpartИ衝■
   TRUNCATE {partition_extended_name ¦ subpartition_exgtended_name}
   [{DROP ¦ REUSE} STORAGE]
   [update_index_clauses [parallel_clause]]

□split_table_partitionИ衝■
   SPLIT partition_extended_name
   {{AT (literal,...) 
     [INTO (range_partition_desc, range_partition_desc)]} ¦
    {VALUES (literal,...) 
     [INTO (list_partition_desc, list_partition_desc)]}
   }
   [dependent_table_clause] 
   [update_index_clauses]
   [parallel_clause]

□split_table_subpartitionИ衝■
   SPLIT subpartition_extended_name
   {{AT (literal,...) 
     [INTO (range_subpartition_desc, range_subpartition_desc)]} ¦
    {VALUES ({literal ¦ NULL},...) 
     [INTO (list_subpartition_desc, list_subpartition_desc)]}
   }
   [dependent_table_clause] 
   [update_index_clauses]
   [parallel_clause]

□merge_table_partitionsИ衝■
   MERGE PARTITION partition_extended_name, partition_extended_name
   [NOT partition_spec]
   [dependent_tables_clause] 
   [update_index_clauses]
   [parallel_clause]

□merge_table_subpartitionsИ衝■
   MERGE SUBPARTITION subpartition_extended_name, subpartition_extended_name
   [NOT {range_subpartition_desc ¦ list_subpartition_desc}]
   [dependent_tables_clause] 
   [update_index_clauses]
   [parallel_clause]

□exchange_partition_subpartИ衝■
   EXCHANGE {partition_extended_name ¦ subpartition_exgtended_name}
   WITH TABLE table
   [{INCLUDING ¦ EXCLUDING} INDEXES]
   [{WITH ¦ WITHOUT} VALIDATION]
   [exception_clause] 
   [update_index_clauses [parallel_clause]]

□exception_clauseИ衝■
   EXCEPTION INTO [schema.] table

□range_values_clauseИ衝■
   VALUES LESS THAN ({literal ¦ MAXVALUE},...)

□list_values_clauseИ衝■
   VALUES ({{literal ¦ NULL},...} ¦ 
            DEFAULT )

□table_partition_descriptionИ衝■
   [segment_attribute_clause]
   [table_compression ¦ key_compression]
   [OVERFLOW [segment_attributes_clause]]
   [{LOB_storage_clause ¦ varray_col_properties}...]

□range_partition_descИ衝■
   range_value_clause table_partition_description
   [{(range_subpartition_desc,... ¦
      list_subpartition_desc,...  ¦
      individual_hash_subparts,...)}     ¦
    hash_subparts_by_quantity]

□list_partition_descИ衝■
   list_values_clause table_partition_description
   [{(range_subpartition_desc,... ¦
      list_subpartition_desc,...  ¦
      individual_hash_subparts,...)}     ¦
    hash_subparts_by_quantity]

□range_subpartition_descИ衝■
   SUBPARTITION [subpartition] range_value_clause
   [partitioning_storage_clause]

□list_subpartition_descИ衝■
   SUBPARTITION [subpartition] list_values_clause
   [partitioning_storage_clause]

□individual_hash_subpartsИ衝■
   SUBPARTITION [subpartition] 
   [partitioning_storage_clause]

□partitioning_storage_clauseИ衝■
   [{TABLESPACE tablespace                   ¦
     OVERFLOW [TABLESPACE tablespace]        ¦
     table_compression                       ¦
     key_compression                         ¦
     LOB_partitioning_clause                 ¦
     {VARRAY varray_item 
       STORE AS [SECUREFILE ¦ BASICFILE]
       LOB LOB_segname}
    }...]
     
□LOB_partitioning_storageИ衝■
   LOB (LOB_item)
   STORE AS [SECUREFILE ¦ BASICFILE]
   [{LOB_segname [(TABLESPACE tablespace)]} ¦
    {(TABLESPACE tablespace)}]

□partition_attributesИ衝■
   [{physical_attribute_clause ¦
     logging_clause            ¦
     allocate_extent_clause    ¦
     deallocate_unused_clause  ¦
     shrink_clause}...]
   [OVERFLOW {physical_attribute_clause ¦
              logging_clause            ¦
              allocate_extent_clause    ¦
              deallocate_unused_clause}...]
   [table_compression]
   [{{LOB LOB_item} ¦ {VARRAY varray}}
    (modify_LOB_parameters)}...]

□partition_specИ衝■
   PARTITION [partition]
   [table_partition_description]

□update_index_clausesИ衝■
   update_global_index_clause ¦
   update_all_index_clause
   
□update_global_index_clausesИ衝■
   {UPDATE ¦ INVALIDATE} GLOBAL INDEXES

□update_all_indexes_clauseИ衝■
   UPDATE INDEXES 
   [({index (update_index_partition ¦
             update_index_subpartition)},...)]

□update_index_partitionИ衝■
   {index_partition_description
    [index_subpartition_clause]},...

□update_index_subpartitionИ衝■
   {SUBPARTITION [subpartition]
    [TABLESPACE tablespace]},... 
 
□index_partition_descriptionИ衝■
   PARTITION [partition]
   [{{segment_attributes_clause ¦ key_compression}...} ¦
    {PARAMETERS ('ODCI_parameters')} ]

□index_subpartition_clauseИ衝■
   {STORE IN (tablespace,...)}         ¦
   {({SUBPARTITION [subpartition] 
      [TABLESPACE tablespace]
      [key_compression]},...)}

□parallel_clauseИ衝■
   NOPARALLEL             ¦
   {PARALLEL [integer]}

□move_table_clauseИ衝■
   MOVE [ONLINE] 
   [segment_attributes_clause]
   [table_compression]
   [index_org_table_clause]
   [{LOB_storage_clause ¦ varray_col_properties}...]
   [parallel_clause]

□flashback_archive_clauseИ衝■
   {FLASHBACK ARCHIVE [flashback_archive]} ¦
   {NO FLASHBACK ARCHIVE}

□enable_disable_clauseИ衝■
   {ENABLE ¦ DISABLE}
   [VALIDATE ¦ NOVALIDATE]
   {UNIQUE (column,...)     ¦
    PRIMARY KEY             ¦
    CONSTRAINT constraint}
   [using_index_clause]
   [exception_clause]
   [CASCADE]
   [{KEEP ¦ DROP} INDEX]

□using_index_clauseИ衝■
   USING INDEX {[schema.] index          ¦
                (create_index_statement) ¦
                index_properties}

□index_propertiesИ衝■
   [{{global_partitioned_index ¦
      local_partitioned_index  ¦
      index_attributes}...}          ¦
    {INDEXTYPE IS {domain_index_clauuse ¦ XMLIndex_clause}}]
   
□index_attributesИ衝■
   [{physical_attributes_clause          ¦
     logging_clause                      ¦
     ONLINE                              ¦
     TABLESPACE {tablespace ¦ DEFAULT}   ¦
     key_compression                     ¦
     {SORT ¦ NOSORT}                     ¦
     REVERSE                             ¦
     {VISIBLE ¦ INVISIBLE}               ¦
     parallel_clause}...]
     

ALTER TABLE 僥
ALTER TABLE 蕨薯