PARTITIONING Clause

Alter table partition properties.

Syntax:

   ADD PARTITION [partition] VALUES LESS THAN (value_list) [partn_description]

   ADD PARTITION [partition] hash_partition_storage

   MODIFY PARTITION partition ADD SUBPARTITION
      [subpartition [ [TABLESPACE tablespace] 
         [LOB_storage_clause] [varray_storage_clause]
             [{NOPARALLEL|PARALLEL int}] ]]

   COALESCE PARTITION [{NOPARALLEL|PARALLEL int}]

   MODIFY PARTITION partition
      COALESCE SUBPARTITION [{NOPARALLEL|PARALLEL int}]

   DROP PARTITION [partition] 

   {ENABLE|DISABLE} ROW MOVEMENT

   MODIFY PARTITION partition storage_&_extents_clause
      [OVERFLOW storage_&_extents_clause]
          [LOB lob_item LOB_parameters][VARRAY varray LOB_parameters]

   MODIFY SUBPARTITION subpartion extent_options

   MODIFY DEFAULT ATTRIBUTES [FOR PARTITION partition] storage_options
      [PCTTHRESHOLD int] [[NO]COMPRESS][OVERFLOW storage_&_extents_clause]
          [LOB lob_item LOB_parameters][VARRAY varray LOB_parameters]

   MODIFY SUBPARTITION subpartion [LOB lob_item modify_LOB_storage_parameters]
      [VARRAY varray modify_LOB_storage_parameters]

   MODIFY PARTITION partition [REBUILD] UNUSABLE LOCAL INDEXES

   MODIFY SUBPARTITION subpartion [REBUILD] UNUSABLE LOCAL INDEXES

   MOVE PARTITION partition [partition description] [{NOPARALLEL|PARALLEL int}]

   MOVE SUBPARTITION subpartion [partition description]

   RENAME [SUB]PARTITION old_name TO new_name

   TRUNCATE [SUB]PARTITION ptn_name [{DROP|REUSE} STORAGE]

   SPLIT PARTITION old_ptn_name AT (value_list)
      [INTO (ptn_spec, ptn_spec)] [{NOPARALLEL|PARALLEL int}]

   MERGE PARTITIONS ptn_1, ptn_2 [INTO (PARTITION [ptn_name][ptn_description])]

   EXCHANGE [SUB]PARTITION WITH TABLE table
      [{INCLUDING|EXCLUDING} INDEXES] [{WITH|WITHOUT} VALIDATION]
         EXCEPTIONS INTO [schema.]table


storage_options:
   PCTFREE int
   PCTUSED int
   INITTRANS int
   MAXTRANS int
   STORAGE storage_clause
   TABLESPACE tablespace
   [LOGGING|NOLOGGING]

storage_&_extents_clause:
   PCTFREE int
   PCTUSED int
   INITTRANS int
   MAXTRANS int
   extent_options
   STORAGE storage_clause
   [LOGGING|NOLOGGING]

extent_options:
   ALLOCATE EXTENT [( [size int K | M ]
      [DATAFILE 'filename' ] [INSTANCE int] )]

   DEALLOCATE UNUSED [KEEP int K | M ]

subptn_clause:
   SUBPARTITION BY HASH (column_list)
     [SUBPARTITIONS quantity [STORE IN (tablespace,...)] ] 
 

Related Commands:

TABLE - CREATE TABLE
TABLE - ALTER TABLE

Related Views:

  DBA_PART_COL_STATISTICS  ALL_PART_COL_STATISTICS  USER_PART_COL_STATISTICS 
  DBA_PART_HISTOGRAMS   ALL_PART_HISTOGRAMS   USER_PART_HISTOGRAMS  
  DBA_PART_INDEXES      ALL_PART_INDEXES      USER_PART_INDEXES    
  DBA_PART_KEY_COLUMNS  ALL_PART_KEY_COLUMNS  USER_PART_KEY_COLUMNS  
  DBA_PART_LOBS         ALL_PART_LOBS         USER_PART_LOBS       
  DBA_PART_TABLES       ALL_PART_TABLES       USER_PART_TABLES