SQL$HELP_OLD72.HLB  —  ALTER  STORAGE_MAP, Format
  ALTER STORAGE MAP <map-name> -+
  +-----------------------------+
  ++-+-++-> ENABLE --+-> COMPRESSION ---------------------------------+-+-+->
   | | |+-> DISABLE -+                                                | | |
   | | +-> COMPILE ---------------------------------------------------+ | |
   | | +-> NO PLACEMENT VIA INDEX ------------------------------------+ | |
   | | +-> PLACEMENT VIA INDEX <index-name> --------------------------+ | |
   | | +-> RENAME PARTITION <partition-name> TO <new-partition-name> -+ | |
   | | +-> REORGANIZE ---+-----------+--------------------------------+ | |
   | | |                 +-> AREAS --+                                | | |
   | | |                 +-> PAGES --+                                | | |
   | | +-> NO REORGANIZE ---------------------------------------------+ | |
   | | +-> store-clause ----------------------------------------------+ | |
   | | +-> PARTITIONING IS UPDATABLE ---------------------------------+ | |
   | | +-> PARTITIONING IS NOT UPDATABLE -----------------------------+ | |
   | | +-> threshold-clause ------------------------------------------+ | |
   | | +-> LOGGING ---------------------------------------------------+ | |
   | | +-> NOLOGGING -------------------------------------------------+ | |
   | | +-> COMMENT IS -+-> 'string' --+-------------------------------+ | |
   | |                 +----  / <-----+                                 | |
   | +------------------- <---------------------------------------------+ |
   +-----------> store-list-clause ---------------------------------------+

  store-clause =

  --> STORE ---+-> IN area-spec ------+->
               +-> across-clause -----+
               +-> using-clause ------+

  area-spec =

  --> <area-name> -+---------------------------------------------------+->
                   +-> ( -++-> threshold-clause ---------------++-> ) -+
                          |+-> LOGGING ------------------------+|
                          |+-> NOLOGGING ----------------------+|
                          |+-> PARTITION <name> ---------------+|
                          |+-> COMMENT IS -+--> 'string' ---+--+|
                          |                +------- / <-----+   |
                          +---------------- ,  -----------------+

  across-clause =

  ---> RANDOMLY ACROSS ---+
   +----------------------+
   +-> ( -+> area-spec --+--> ) -->
          +----- , <-----+

  using-clause =

  ---> USING ---> (  -+-> <column-name> -+-> ) ------------------+
                      +-------- , <------+                       |
  +--------------------------------------------------------------+
  ++-> IN area-spec -> WITH LIMIT OF --> ( +-> <literal> -+> ) +-+
   |                                       +------ , <----+    | |
   +--------------------------<--------------------------------+ |
   +--------------------------<----------------------------------+
   ++------------------------------------------------+------------->
    +> OTHERWISE IN area-spec -----------------------+

  threshold-clause =

  --+-> THRESHOLD -+-> IS -+-> ( --> <val1> --> ) ---------+->
    |              +-> OF -+                               |
    |                                                      |
    +-> THRESHOLDS -+-> ARE -+-----------+                 |
                    +-> OF  -+           |                 |
      +----------------------------------+                 |
      +-> ( --> <val1> -+---------------------------+-> ) -+
                        +-> , <val2> -+-------------+
                                      +-> , <val3> -+

  store-lists-clause =

  --->  STORE LISTS ---+
    +------------------+
    +-+->  IN -+-> area-spec ---------------+---+----------->
      |        +-> ( +> area-spec -> ) ----++   |
      |              +------ , <-----------+    |
      | +---------------------------------------+
      | +-+------------------------>-----------------------+
      |   +-> FOR -> ( -+-> <table-name> ---------+-> ) -+ |
      |                 +-> <table-name.col-name> +      | |
      |                 +-------- , <-------------+      | |
      |           +--------------------------------------+ |
      |           +---+------------>----------+------------+
      |               +-> FILL RANDOMLY  -----+            |
      |               +-> FILL SEQUENTIALLY --+            |
      +----------------------------<-----------------------+
Close Help