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.

These options don't seem to be supported properly yet, but should be:

  • PCTUSED - Should be supported
  • Parallel - Should be supported
  • NoParallel - Should be supported
  • ROWDEPENDENCIES -Not supported (12c only option, so not supported in current plugin)
  • NOROWDEPENDENCIES -Not supported (12c only option, so not supported in current plugin)
  • FREELISTS -Not supported
  • FREELIST GROUPS -Not supported
  • PCTINCREASE -Not supported

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
  • INITRANS
  • CACHELOGGING
  • NOCACHE
  • NOLOGGING
  • NOPARALLEL
  • INITRANSPARALLEL
  • LOGGINGREAD ONLY
  • NOLOGGINGREAD WRITE
  • RESULT_CACHE
  • PCTFREE


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:

  • TABLESPACE_NAME
  • INITIALEXTENT
  • NEXTEXTENT
  • MINEXTENTS
  • MAXEXTENTS
  • INITIAL
  • NEXTCOMPRESS
  • 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
  • TABLESPACE_NAMEMAXTRANS
  • NEXT
  • PCTFREE
  • PCTINCREASE
  • PCTUSED
  • RECOVERABLE
  • TABLESPACE
  • UNRECOVERABLE