Versions Compared

Key

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

...

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:

...

  • FREELIST GROUPS
  • FREELISTS 
  • INITIAL
  • INITIAL
  • INITIALEXTENT
  • NEXTEXTENTMAXEXTENTS
  • MINEXTENTS
  • MAXEXTENTS
  • INITIAL
  • NEXT
  • ROWDEPENDENCIESNEXTEXTENT
  • NOROWDEPENDENCIES
  • FREELISTS PCTFREE
  • FREELIST GROUPS
  • PCTINCREASE 
  • PCTUSED
  • PCTFREEROWDEPENDENCIES
  • TABLESPACE

The plugin currently supports changing these

...

options on an index:

  • COMPRESS
  • INITRANS
  • LOGGING
  • NOCOMPRESS
  • NOLOGGING
  • PARALLEL
  • NOPARALLEL
  • INITRANS
  • COMPRESSPARALLEL
  • NOCOMPRESS

The plugin currently does not support changing these

...

options on an index:

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



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