0
N
TABLE_ORGANIZATION
PARSE
PARSE
SQL
PARSE
SQL
FREELIST_GROUPS
INITIAL
MINEXTENTS
SEGMENT_CREATION_DEFERRED
NAME
CLAUSE_TYPE
PHYSICAL_ATTRIBUTES
ALTER TABLE
TABLE
PCTFREE
PCTUSED
INITRANS
PCTFREE
PCTUSED
INITRANS
TABLE
NAME
CLAUSE_TYPE
DEFERRED_SEGMENTS
ALTER TABLE
ALLOCATE EXTENT
MOVE
STORAGE (
INITIAL
NEXT
MINEXTENTS
MAXEXTENTS
PCTINCREASE
FREELISTS
FREELIST GROUPS
BUFFER_POOL
FLASH_CACHE
CELL_FLASH_CACHE
)
STORAGE (
NEXT
MAXEXTENTS
PCTINCREASE
FREELISTS
BUFFER_POOL
FLASH_CACHE
CELL_FLASH_CACHE
)
TABLESPACE
NOCOMPRESS
DROP
ADD
N
DROP
ADD
N
N
PARSE
SQL
NAME
CLAUSE_TYPE
ADD_SUPPLEMENTAL_LOGGING
DROP_SUPPLEMENTAL_LOGGING
ALTER TABLE
ADD
DROP
SUPPLEMENTAL LOG GROUP
(
)
ALWAYS
N
PARSE
SQL
NAME
CLAUSE_TYPE
ADD_SUPPLEMENTAL_ID_KEY
DROP_SUPPLEMENTAL_ID_KEY
ALTER TABLE
ADD
DROP
SUPPLEMENTAL LOG DATA (
ALL
PRIMARY KEY
UNIQUE INDEX
FOREIGN KEY
) COLUMNS
TABLE
TABLE
TABLE
PARSE
SQL
NAME
CLAUSE_TYPE
ALTER_TABLE_PROPERTIES
TABLE_PROPERTIES
ROW_MOVEMENT
ALTER
ENABLE ROW MOVEMENT
DISABLE ROW MOVEMENT
PARSE
SQL
NAME
CLAUSE_TYPE
ALTER_TABLE_PROPERTIES
TABLE_PROPERTIES
CACHE
CLAUSE_TYPE
CACHE
ALTER
ON
NOCACHE
CACHE
PARSE
SQL
NAME
CLAUSE_TYPE
ALTER_TABLE_PROPERTIES
TABLE_PROPERTIES
PARALLEL
CLAUSE_TYPE
PARALLEL
ALTER
ON
NOPARALLEL
PARALLEL (
DEGREE
INSTANCES
)
PARALLEL
NOPARALLEL
PARSE
SQL
NAME
CLAUSE_TYPE
ALTER_TABLE_PROPERTIES
TABLE_PROPERTIES
FLASHBACK_ARCHIVE
ALTER TABLE
ALTER TABLE
NO FLASHBACK ARCHIVE
begin dbms_lock.sleep(20); end;
ALTER TABLE
NO FLASHBACK ARCHIVE
begin dbms_lock.sleep(20); end;
ALTER TABLE
Mapping table clause not supported with materialized views
PARSE
SQL
NAME
CLAUSE_TYPE
PHYSICAL_ATTRIBUTES
MAPPING
ALTER TABLE
MOVE NOMAPPING
MOVE MAPPING TABLE
PARSE
SQL
NAME
CLAUSE_TYPE
PHYSICAL_ATTRIBUTES
PCTTHRESHOLD
ALTER TABLE
ALTER MATERIALIZED VIEW
PCTTHRESHOLD 0
PCTTHRESHOLD
MV_KEYCOMPRESS
PARSE
SQL
NAME
CLAUSE_TYPE
PHYSICAL_ATTRIBUTES
KEYCOMPRESS
ALTER TABLE
NOCOMPRESS
MOVE COMPRESS
NOCOMPRESS
DROP_OVERFLOW
OVERFLOW_TABLESPACE
ADD
PARSE
SQL
NAME
CLAUSE_TYPE
ADD_OVERFLOW
ALTER_OVERFLOW
OVERFLOW CLAUSE
PCTFREE
PCTUSED
INITRANS
INCLUDING COLUMN
ALTER TABLE
ALTER MATERIALIZED VIEW
ADD OVERFLOW
ALTER TABLE
ALTER MATERIALIZED VIEW
INCLUDING
ALTER TABLE
ALTER MATERIALIZED VIEW
OVERFLOW
ALTER TABLE
ALTER MATERIALIZED VIEW
INCLUDING
(
PARTITION
,
)
FREELIST GROUPS
DEFAULT DIRECTORY "
REJECT LIMIT
RETURN AS
STORE AS
"
"
"
"
"
LOGGING
NOLOGGING