CTXSYS drop an index from dr$index
Hi All,
I'm not that good with Oracle Text so I would like to ask some experts on how to remove an index from ctxsys.dr$index and all subsequent tables in the ctxsys schema.
An Oracle Text index was created as the user SYS and I found entry in ctxsys.dr$index. The index doesn't exist in the SYS schema so I would like to know if there is a function to delete an index with a certain ID from all table resided in the ctxsys schema dr$index etc.
Hope there is a function to do this.
Thanks for any help.
Edited by: user10148486 on 19-okt-2012 2:21