Originally posted by adewri
Abhay, here i would like to comment that status values for indexes can be 'VALID' or 'UNUSABLE'. Other stored objects can be 'VALID' or 'INVALID.' Either all_indexes, DBA_INDEXES or USER_INDEXES should be querried for the status of indexes.
HTH
Amar I didnt literally mean INVALID...it was jus to empasize theat indexes wud be unused if u moved the table.
Abhay.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
Reply With Quote