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 Oracle 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 © 1999-2024 SS64.com
Some rights reserved