This page refers to support as of version 4.0.3.???. Please verify that you are running that version if you are using this page as a reference. Earlier versions may not support all of these options. Please find the latest version at the support site.
These options don't seem to be supported properly yet, but should be:
- PCTUSED - Should be supported
The plugin does not support changes to partitioning for either indexes or tables at this point.
The plugin currently supports changing these
...
options on a table:
- READ ONLY
- READ WRITE
- ENABLE BUFFER_POOL
- CACHE
- DISABLE ROW MOVEMENTDISABLE
- ENABLE ROW MOVEMENT
- CACHE
- NOCACHE
- INITRANS
- LOGGING
- NOCACHE
- NOLOGGING
- RESULT_CACHE
- PCTFREENOPARALLEL
- PARALLEL
- NOPARALLEL
The plugin currently supports changing these storage options on a table:
- BUFFER_POOLREAD ONLY
- READ WRITE
- RESULT_CACHE
The plugin currently does not support changing these options on a table:
- TABLESPACE_NAMEFREELIST GROUPS
- FREELISTS
- INITIAL
- INITIALEXTENT
- MAXEXTENTS
- MINEXTENTS
- NEXT
- NEXTEXTENT
- MINEXTENTSNOROWDEPENDENCIES
- MAXEXTENTSPCTFREE
- INITIALPCTINCREASE
- NEXTPCTUSED
- ROWDEPENDENCIES
- NOROWDEPENDENCIES
- FREELISTS
- FREELIST GROUPS
- PCTINCREASE TABLESPACE
The plugin currently supports changing these options on an index:
- COMPRESS
- DIRECTION
- INITRANS
- LOGGING
- NOCOMPRESS
- NOLOGGING
- NOPARALLEL
- PARALLEL
The plugin currently does not support changing these
...
options on an index:
- TABLESPACE_NAME
- FREELISTS
- FREELIST GROUPSFREELIST GROUPS
- FREELISTS
- GLOBAL
- INITIAL
- LOCAL
- MAXTRANS
- NEXT
- PCTFREE
- PCTINCREASE
- PCTUSED
- RECOVERABLE
- TABLESPACE
- UNRECOVERABLE