STORAGE Clause

Storage options that apply to tables, indexes, clusters, mviews and rollback segments.

Syntax:

   STORAGE options 

Options

   INITIAL int K | M
   NEXT int K | M
   MINEXTENTS int
   MAXEXTENTS int
   MAXEXTENTS UNLIMITED
   PCTINCREASE int
   FREELISTS int
   FREELIST GROUPS int
   OPTIMAL
   OPTIMAL int K | M
   OPTIMAL NULL
   BUFFER POOL {KEEP|RECYCLE|DEFAULT}

Related Commands:

INDEX - ALTER INDEX
TABLE - ALTER TABLE
MVIEW - ALTER MATERIALIZED VIEW (Snapshot)
MVIEW LOG - ALTER MATERIALIZED VIEW LOG

Related Views:

DBA_DATA_FILES
FILEXT$
SYSFILES
DBA_TEMP_FILES


© Copyright SS64.com 1999-2013
Some rights reserved