CREATE STORAGE MAP <map-name> --+ +------------------------------+ ++-----------------------------------+-+ +-> STORED NAME IS <stored-name> ---+ | +--------------------------------------+ +> FOR <table-name> ++-------------------------------------++-+ | |++> ENABLE -+> COMPRESSION -----------+| | | ||+> DISABLE + || | | |+-> PLACEMENT VIA INDEX <index-name> -+| | | |+-> partition-updatable-clause -------+| | | |+-> threshold-clause -----------------+| | | |+-> LOGGING ---------------------------+ | | |+-> NOLOGGING -------------------------+ | | |+-> COMMENT IS -+-> '<string>' ---+----+ | | | +-------- / <-----+ | | | +-----------------<---------------------+ | | +---------------------------------------------------------+ | +-+----------------------+-+-------------------------------> | +-> partition-clause --+ | +> store-lists-clause ---------+ partition-updatable-clause = ---> PARTITIONING IS -+-> NOT UPDATABLE -+--> +-> UPDATABLE -----+ threshold-clause = --+-> THRESHOLD -+-> IS -+-> ( --> <val1> --> ) ---------+-> | +-> OF -+ | | | +-> THRESHOLDS -+-> ARE -+-----------+ | +-> OF -+ | | +----------------------------------+ | +-> ( --> <val1> -+---------------------------+-> ) -+ +-> , <val2> -+-------------+ +-> , <val3> -+ partition-clause = -+> STORE -+------------------++--------------------+> store-clause -+> | +> columns-clause -++> store-attributes -+ | +------------------------------- <----------------------------------+ columns-clause = -> COLUMNS --> ( -+-> <column-name> -+-> ) --> +-------- , <------+ store-attributes = --+-+-+-> ENABLE --+-> COMPRESSION -+-+--> | | +-> DISABLE -+ | | | +-> thresholds-clause ----------+ | | +-> VERTICAL PARTITION <name> --+ | +--------------- <------------------+ store-clause = ---+-> 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 -----------------------+ store-lists-clause = ---> STORE LISTS ---+ +------------------+ +-+-> IN -+-> area-spec ---------------+---+-----------> | +-> ( +> area-spec -> ) ----++ | | +------ , <-----------+ | | +---------------------------------------+ | +-+------------------------>-----------------------+ | +-> FOR -> ( -+-> <table-name> ---------+-> ) -+ | | +-> <table-name.col-name> + | | | +-------- , <-------------+ | | | +--------------------------------------+ | | +---+------------>----------+------------+ | +-> FILL RANDOMLY -----+ | | +-> FILL SEQUENTIALLY --+ | +----------------------------<-----------------------+