Oracle Text (MOSC)

MOSC Banner

CTX index invisible Partitions

edited Jun 26, 2013 4:26AM in Oracle Text (MOSC) 2 commentsAnswered
I have tried to drop the CTX Index with Force option. Though the index and the associated Prefertences were dropped.

I still see the Partitions associated with the CTX index is still listed in user_objects. The same partitions dont exist in user_ind_partitions. The index associated with these partitions also dont exist in user_indexes. Any thoughts on this behgavior of CTX Index..?

It is not allowing to create the Index back again because of these partitions. we are not able to drop these partitions manually either as the index is not existing.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center