Differences

This shows you the differences between two versions of the page.

--- onlineddl [2015/08/25 12:50] – z0hpvk
+++ onlineddl [2025/03/08 22:24] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
 ===== New Online DDL Capabilities =====
-  * Drop Index
+===Drop Index===
-<code>drop index ian.idx1 online;</code>
+<code>DROP INDEX ian.idx1 ONLINE;</code>
-  * Drop Constraint
+===Drop Constraint===
-  *
+<code>ALTER TABLE ian.tab1 DROP CONSTRAINT name_fk ONLINE;</code>
+===Mark Index Unusable===
+<code>ALTER INDEX ian.idx2 UNUSABLE ONLINE;</code>
+===Mark Column Unused===
+<code>ALTER TABLE ian.tab1 SET UNUSED (name) ONLINE;</code>