Timeline for Oracle 11: Change global index to local on huge production table
Current License: CC BY-SA 3.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 20, 2013 at 13:21 | comment | added | user31967 | Also look at using NOLOGGING and PARALLEL clauses when rebuilding indexes online ... | |
| Sep 20, 2012 at 19:44 | vote | accept | WBAR | ||
| Sep 17, 2012 at 12:01 | history | tweeted | twitter.com/#!/StackDBAs/status/247666642383949824 | ||
| Sep 16, 2012 at 20:11 | history | migrated | from stackoverflow.com (revisions) | ||
| Sep 16, 2012 at 11:37 | answer | added | WBAR | timeline score: 3 | |
| Jul 9, 2012 at 6:50 | comment | added | WBAR |
Only solution I found is when system has the low load, I executed: 1) Dropped global index 2) Dropped unused / archived partitions 3) Created local index with adding ONLINE word at end forcing to index be calculated on the fly without blocking my table.
|
|
| Jun 4, 2012 at 11:49 | comment | added | WBAR |
UPDATE GLOBAL INDEXES how long it takes ? Like creating new one ?
|
|
| Jun 4, 2012 at 11:26 | comment | added | Vincent Malgrat |
Global indexes won't be unusable after a partition drop if you specify UPDATE GLOBAL INDEXES. This doesn't answer your main question (transform a global index into a local index) but might help you with dropping partitions.
|
|
| Jun 4, 2012 at 11:19 | comment | added | WBAR | can You, Sir, be more specific? Dropping partition makes global index unavailable. After dropping that global index i have couple o seconds when new local must be up and running | |
| Jun 4, 2012 at 11:11 | comment | added | Vincent Malgrat |
Have you tried ALTER TABLE... DROP PARTITION ... UPDATE GLOBAL INDEXES?
|
|
| Jun 4, 2012 at 10:48 | history | asked | WBAR | CC BY-SA 3.0 |