Supported and Unsupported Table and Index options

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