Hello all,
I have noticed that in Oracle 19c, after a Create Index Online is aborted, the index is still displayed as Existing and Valid in the Data Dictionary (DBA_INDEXES).
When trying to drop this zombie I get the error:
"ORA-08104: this index object 2547068 is being built or rebuilt online".
Now I can remove the index manually with the DBMS_REPAIR package. But in 12.1 (and before) it was different.
If a CREATE INDEX ONLINE was terminated there, then no zombie was to be found in the Data Dictionary. So you could clearly see that the index was missing.
I don't understand now if this is a bug or a feature.
Tagged:
0