Supported and Unsupported Table and Index options

Owned by Karl Henselin
Last updated: Oct 20, 2017
1 min read

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