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:53] – z0hpvkonlineddl [2025/03/08 22:24] (current) – external edit 127.0.0.1
Line 2: Line 2:
 ===Drop Index=== ===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.1440507192.txt.gz · Last modified: 2025/03/08 22:23 (external edit)