RECREATE_INDEX_ONLINE failed - ran out of space - Now I cannot issue the recreate_index_online comma
Summary:
We have a tablespace (tindx) which is used just to house Oracle Text indexes.
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.
0