change owner of indexes

[jn1971]

Hi,

After i finished recreating indexes, i realized that i did not use a correct userid. i got bunch of a.indexes instead of b.indexes. Is there any way to rename a.indexes to b.indexes w/o reindexing? Thanks.

Jeanie :(

[ngupta15]

probably, you need to drop and recreate index OR if you have all the permissions (as you said index are created under another user) on on the table, just try alter index ...... rebuild.