Oracle Text (MOSC)

MOSC Banner

RECREATE_INDEX_ONLINE failed - ran out of space - Now I cannot issue the recreate_index_online comma

edited Nov 15, 2012 4:35AM in Oracle Text (MOSC) 2 commentsAnswered
Summary:
We have a tablespace (tindx) which is used just to house Oracle Text indexes.

I tried to rebuild one of the text indexes (person_kw_idx) over the weekend using the ctx_dll.recreate_index_online command.  During the processing, I ran out of space in the tablespace.  The reason I was rebuilding the index was I was adding a wordlist preference for wildcard optimization.

I added more space and tried to reissue the command.  I was told the object name was already in use.  I tried to drop_shadow_index, which appears to work, but when I reissue the command, I'm told the object name is already in use.

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