Trial Update: Create update scripts but don't run them
Schema Pseudonym: Create/update a schema as another name
Tokenisation: Insert/replace tokens for common environment values
Reference Data: Populate tables with reference data.
Manage Object Grants, Role Grants, System Privs and Synonyms: Centralised grant control.
Configurable Deploy User: Configure by environment, schema and object type
Build Project
Import Project
Export DB
Scrub DB
Deploy DB
Update DB
Full Code Update: Force all code objects to be updated
Delta Update: Only apply code objects that have changed since the last update.
Patches: Apply SQL scripts once only.
Bootstrap Patches: Patches to setup the database (Run as SYS).
First Patches: Patches to setup a schema; before update (Run as the schema).
Last Patches: Patches that run after a schema update (Run as the schema).
Final Patches: Patches that run after database update.
Flashback: Use Oracle flashback to reduce build times. This could use VM snaphots.
Snapshot build: Throw away builds for CI environments
Release build: Tagged build for use in controlled environments.
Stop Build for Ref-Data: Indexes can be disabled/enabled for data import.
Materialised views in:
a) Baseline are applied after views as they could be referencing views
b) Patches are applied after baseline as they could be referencing views or baseline MV's.