Features Demonstrated
This tutorial will demonstrate some of the major enhancements which will reduce
the database downtime.
- Alter Table Enhancements:
- How to add columns in a table
- How to rename columns in a table
- How column datatypes can be changed
- Object Auto Revalidation
- How views can be created before the underlying tables
- How database objects can be recreated without the DROP command
- How database objects are automatically revalidated due to changes to the underlying dependencies
- Online Table Move
- How to move table from one schema to another schema
- How to move table from one schema to another schema using LOAD option
All of these operations can now be performed online without any outages