0 N NAME NOT_ALTERABLE TABLE_ORGANIZATION -- Cannot ALTER physical organization of TABLE PARSE SQL NAME CLAUSE_TYPE PHYSICAL_ATTRIBUTES NOT_ALTERABLE FREELIST GROUPS NOT_ALTERABLE INITIAL NOT_ALTERABLE MINEXTENTS NOT_ALTERABLE SEGMENT_CREATION_DEFERRED -- Cannot ALTER to make segment creation deferred TABLE ALTER TABLE PCTFREE PCTUSED INITRANS MOVE PCTFREE PCTUSED INITRANS STORAGE ( INITIAL NEXT MINEXTENTS MAXEXTENTS PCTINCREASE FREELISTS FREELIST GROUPS BUFFER_POOL FLASH_CACHE CELL_FLASH_CACHE ) STORAGE ( NEXT MINEXTENTS MAXEXTENTS PCTINCREASE FREELISTS BUFFER_POOL FLASH_CACHE CELL_FLASH_CACHE ) TABLESPACE NOCOMPRESS COMPRESS FOR ALL OPERATIONS COMPRESS 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 PARSE SQL NAME CLAUSE_TYPE PHYSICAL_ATTRIBUTES MAPPING NOT_ALTERABLE MAPPING ALTER TABLE MOVE NOMAPPING MOVE MAPPING TABLE -- cannot alter MAPPING in Index-Oranized MATERIALIZED VIEW PARSE SQL NAME CLAUSE_TYPE PHYSICAL_ATTRIBUTES PCTTHRESHOLD ALTER TABLE ALTER MATERIALIZED VIEW PCTTHRESHOLD 0 PCTTHRESHOLD PARSE SQL NAME CLAUSE_TYPE PHYSICAL_ATTRIBUTES KEYCOMPRESS NOT_ALTERABLE KEYCOMPRESS ALTER TABLE -- can not alter COMPRESS in index-organized ALTER MATERIALIZED VIEW NOCOMPRESS MOVE COMPRESS NOCOMPRESS DROP ADD PARSE DROP ADD SQL NAME CLAUSE_TYPE CAN NOT DROP OVERFLOW ADD_OVERFLOW ALTER_OVERFLOW OVERFLOW CLAUSE PCTFREE PCTUSED INITRANS INCLUDING COLUMN NOT_ALTERABLE TABLESPACE 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