Changing the owner on an index

Changing the owner on an index

 

  

Does anyone know of a way to change the owner on an index without dropping
and re-creating it? During a recovery operation, we ended up with a bunch
of indexes owned by sys instead of the table owner, and we want to switch
them back without dropping them.


Andrew W. Kerber
NAIC
816-783-8583
[Email Address Removed] at first you dont succeed, dont take up skydiving.'

Oracle LazyDBA home page