New Online DDL Capabilities

Drop Index

DROP INDEX ian.idx1 ONLINE;

Drop Constraint

ALTER TABLE ian.tab1 DROP CONSTRAINT name_fk ONLINE;

Mark Index Unusable

ALTER INDEX ian.idx2 UNUSABLE ONLINE;

Mark Column Unused

ALTER TABLE ian.tab1 SET UNUSED (name) ONLINE;