Baseline and Synchronize Supported Object Types

This list is current as of release 4.6.0.3.24

  • Sequence

    • Grants are brought along if present
  • Table

    • Grants are brought along if present
    • In partial deploy mode, selecting a table selects the associated Columns, Constraints, and, indexes as well.
    • Index columns are compared and altered as needed.
    • For more detains, see Supported and Unsupported Table and Index options
  • View

    • Grants are brought along if present
    • In partial deploy mode, selecting a view selects the associated Columns, Constraints, and, indexes as well.
  • Materialized View

    • Grants are brought along if present
    • In partial deploy mode, selecting a view selects the associated Columns, Constraints, and, indexes as well.
  • Materialized View Log

  • Synonym

    • Grants are brought along if present
  • Function

    • Grants are brought along if present
  • Trigger

    • Grants are brought along if present
  • Type

    • Grants are brought along if present
  • Type Body

    • Grants are brought along if present
  • Package

    • Grants are brought along if present
  • Package Body

  • Procedure

    • Grants are brought along if present
  • Queue

    • Queues bring their Queue Tables, Schedules,  Subscribers, and grants with them.
  • Java

    • Only Java Source is baselined and migrated at this time.
    • Grants are brought along if present
  • Transformation


Clarifications

Grants support the "with grant option"

Queue Publishers are not supported.

Queue Agents are not supported.

Column object grants or not baselined or deployed

Invalid Types are not baselined.

The plugin requires that constraints and indexes share the same name.

Features delivered by Oracle in 12.1 (like invisible columns) are not currently supported by the plugin.



The following macros are not currently supported in the footer:
  • style