DB Wiki

DROP INDEX ian.idx1 ONLINE;

ALTER TABLE ian.tab1 DROP CONSTRAINT name_fk ONLINE;

ALTER INDEX ian.idx2 UNUSABLE ONLINE;

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