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 --+ | +----------------------------<-----------------------+