alter table move-issues, disappearing indexes
Hi,
I've done this dozens of times, but today I have a strange issue on 11g rel.2:
We have a bunch of tablespace on manual segment space management. These have to be migrated to automatic segment space management. The tablespace has only simple tables with corresponding indexes and a few lob-segments.
So I renamed the tablespace TSNAME to TSNAME_OLD and created a new TSNAME, so that we don't get strange filenames in ASM.
I did a rebuild multiple objects in Toad by rebuilding tables in TSNAME_OLD and giving as storage clause TSNAME as the target tablespace. This went well, but afterwards a bunch of indexes in another tablespace are gone. Thougth that it might be a toad-issue, so I did manually the move of the tables (well created a script for this as >500 tables moving and entering 1 by 1 isn't a funny thing ;-) ), but with the same result. Indexes are disappearing. Actually over 1000.
I've done this dozens of times, but today I have a strange issue on 11g rel.2:
We have a bunch of tablespace on manual segment space management. These have to be migrated to automatic segment space management. The tablespace has only simple tables with corresponding indexes and a few lob-segments.
So I renamed the tablespace TSNAME to TSNAME_OLD and created a new TSNAME, so that we don't get strange filenames in ASM.
I did a rebuild multiple objects in Toad by rebuilding tables in TSNAME_OLD and giving as storage clause TSNAME as the target tablespace. This went well, but afterwards a bunch of indexes in another tablespace are gone. Thougth that it might be a toad-issue, so I did manually the move of the tables (well created a script for this as >500 tables moving and entering 1 by 1 isn't a funny thing ;-) ), but with the same result. Indexes are disappearing. Actually over 1000.
0