Missing "update global indexes" clause in sql, when using a split partition.
To reproduce this issue:
1. Highlight a partitioned table in the Schema Browser
2. Pick the "Partitions" tab on the right side
3. Click on "Alter/Add Partitions"
4. Highlight one partition and click "Split"
5. Enter the values for the new partition
6. Mark "Update Global Indexes"
7. Click "OK"
8. Click "Show SQL"
The script shows the alter table statement but the "update global indexes" clause is missing.
9. Click "OK" to run the split
Now Global Indexes are marked as "unusable" since they are rebuilt.
If the sql script in step 8 would have the "update global indexes" clause, as given in step 6, it would work correctly.
WORKAROUND:
Please amend the SQL Statement manually.
STATUS:
Waiting for a fix to be released in a future version of Toad for Oracle.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center