Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

CTXSYS drop an index from dr$index

user10148486Oct 19 2012 — edited Oct 19 2012

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 16 2012

Added on Oct 19 2012

#database-key-features, #text

1 comment

1,277 views