cartridge index cannot be created because of an error that states that "Object Name already in use"

cartridge index cannot be created because of an error that states that "Object Name already in use"

Occasionally we come across an oracle server where a cartridge index cannot be created because of an error that states that "Object Name already in use". This typically happens if the index was left in a bad state by a failed creation, deletion, or indexing action.

The first line of defense is to drop the index using:

Where XX is the index name.

This typically cleans up all internal objects and allows the recreation of the index.

At times, even this does not work. The recommended action is to look for any tables remaining in the cscartridge schema associated with your index and manually delete them.

If that does not work, then it can be that other internal cartridge objects related to your index are still hanging around. For example, I have seen instances were a sequence was still left behind causing the recreation of the index to fail.

A quick way to look for any lingering cartridge objects is:

select * from all_objects where object_name like '%REGDB%';

where REGDB in my case was the name of the user that created the index.

Drop any objects associated with your index and then recreate it.