Supported and Unsupported Table and Index options

This page refers to support as of version 4.0.3.58. 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.

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:

  • BUFFER_POOL
  • CACHE
  • DISABLE ROW MOVEMENT
  • ENABLE ROW MOVEMENT
  • INITRANS
  • LOGGING
  • NOCACHE
  • NOLOGGING
  • NOPARALLEL
  • PARALLEL
  • READ ONLY
  • READ WRITE
  • RESULT_CACHE

The plugin currently does not support changing these options on a table:

  • FREELIST GROUPS
  • FREELISTS 
  • INITIAL
  • INITIALEXTENT
  • MAXEXTENTS
  • MINEXTENTS
  • NEXT
  • NEXTEXTENT
  • NOROWDEPENDENCIES
  • PCTFREE
  • PCTINCREASE 
  • PCTUSED
  • ROWDEPENDENCIES
  • 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:

  • FREELIST GROUPS
  • FREELISTS 
  • GLOBAL
  • INITIAL
  • LOCAL
  • MAXTRANS
  • NEXT
  • PCTFREE
  • PCTINCREASE
  • PCTUSED
  • RECOVERABLE
  • TABLESPACE
  • UNRECOVERABLE



The following macros are not currently supported in the footer:
  • style