Originally posted by quester
Wonder why didn't Oracle take care of such small things in 9i. All it was supposed to do is rebuild the index whenever such operations happened. Wonder if there is any specific reason why they didn't do it (or did they overlook such issues !)
Good Q...i blv they wudnt have overlooked..

Probably oracle corp guys might have thought....i mean logically...
that when user wants to move a table, then he may want to recreate the index in diff tablespace...in that case it wud be uswise to rebuild itself...

i am waiting for Jomodic to come up with resaons...

abhay.