Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

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_CACHENOPARALLEL
  • 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
  • NEXTEXTENTMAXEXTENTS
  • MINEXTENTS
  • MAXEXTENTS
  • INITIAL
  • NEXT
  • ROWDEPENDENCIESNEXTEXTENT
  • NOROWDEPENDENCIES
  • FREELISTS 
  • FREELIST GROUPSPCTFREE
  • PCTINCREASE 
  • PCTUSED
  • ROWDEPENDENCIES
  • PCTFREETABLESPACE


The plugin currently supports changing these

...

options on an index:

  • COMPRESS
  • DIRECTION
  • INITRANS
  • LOGGING
  • NOCOMPRESS
  • NOLOGGING
  • PARALLEL
  • NOPARALLEL
  • INITRANS
  • COMPRESS
  • NOCOMPRESSPARALLEL


The plugin currently does not support changing these

...

options on an index:

  • TABLESPACEFREELIST GROUPS
  • FREELISTS 
  • FREELIST GROUPS
  • PCTINCREASE
  • PCTUSEDGLOBAL
  • INITIAL
  • LOCAL
  • MAXTRANS
  • NEXT
  • PCTFREE
  • INITIALPCTINCREASE
  • NEXTPCTUSED
  • MAXTRANSRECOVERABLERECOVERABLE
  • TABLESPACE
  • UNRECOVERABLE
  • LOCAL
  • GLOBAL