DB Wiki

User Tools

Site Tools

Trace:
onlineddl

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
onlineddl [2015/08/25 12:52] – z0hpvkonlineddl [2025/03/08 22:24] (current) – external edit 127.0.0.1
Line 1: Line 1:
 ===== New Online DDL Capabilities ===== ===== New Online DDL Capabilities =====
 +===Drop Index===
 <code>DROP INDEX ian.idx1 ONLINE;</code> <code>DROP INDEX ian.idx1 ONLINE;</code>
 +===Drop Constraint===
 <code>ALTER TABLE ian.tab1 DROP CONSTRAINT name_fk ONLINE;</code> <code>ALTER TABLE ian.tab1 DROP CONSTRAINT name_fk ONLINE;</code>
 +===Mark Index Unusable===
 <code>ALTER INDEX ian.idx2 UNUSABLE ONLINE;</code> <code>ALTER INDEX ian.idx2 UNUSABLE ONLINE;</code>
 +===Mark Column Unused===
 <code>ALTER TABLE ian.tab1 SET UNUSED (name) ONLINE;</code> <code>ALTER TABLE ian.tab1 SET UNUSED (name) ONLINE;</code>
  
onlineddl.1440507172.txt.gz · Last modified: 2025/03/08 22:23 (external edit)