8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23ai | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
Online Operation Enhancements in Oracle Database 12c Release 1 (12.1)
Oracle database 12c includes a number of new online operations. This article brings together all the articles related to online operations in Oracle Database 12c Release 1.
- Online Move of Partitions and Sub-Partitions
- Online Statistics Gathering for Bulk Loads
- Invisible Columns
- Metadata-Only DEFAULT Values
- Online Move Datafile
- Multiple Indexes on the Same Set of Columns
- Online Operations
Online Operations
In addition to the articles listed above, the following operations are now non-blocking provided the ONLINE
keyword is used.
ALTER TABLE table-name DROP CONSTRAINT contraint-name ONLINE;
ALTER TABLE table-name SET UNUSED (column-list) ONLINE;
DROP INDEX index-name ONLINE;
ALTER INDEX index-name UNUSABLE ONLINE;
ALTER TABLE table_name MOVE PARTITION partition-name ONLINE ...;
ALTER TABLE table_name MOVE SUBPARTITION partition-name ONLINE ...;
The following operations are non-blocking without the ONLINE
keyword.
ALTER INDEX index-name INVISIBLE;
ALTER INDEX index-name VISIBLE;
For more information see:
Hope this helps. Regards Tim...