Online Operations in Oracle 11g/ 12c (12.1) /12c (12.2) / 18c /19c Databases

 

Online Operations in Oracle 11g/ 12c (12.1) /12c (12.2) / 18c Databases

Online Operations in Oracle 11g/12c (12.1)/12c (12.2)/18c Databases

Oracle 11g (11.2) & Prior

--------------------------

1. Create index online

2. rebuild index online

3. rebuild index partition online

4. Add Column

5. Add Constraint enable novalidate

Oracle 12c (12.1)

------------------

1. Online move partition

2. Drop index online

3. Set unused column online

4. alter column visible/invisible

5. alter index unusable online

6. alter index visible/invisible 

7. alter index parallel/noparallel

Oracle 12c (12.2)

------------------

1. Alter table  move online for non-partitioned tables

2. Alter table  from non-partitioned to partitioned online

3. Alter table  split partition online

4. Create table for exchange (usable for online partition exchange)

5. Move/merge/split partition maintenance operations can now do data filtering

Oracle 18c/19c

----------------

1. Alter table modify partitioned table to a different partitioning method

2. Alter table merge partition/subpartition online