Oracle 19c SMON doesn't clears a canceled online index creation. Bug or Feature? — oracle-mosc

SQL Language (MOSC)

MOSC Banner

Oracle 19c SMON doesn't clears a canceled online index creation. Bug or Feature?

edited Oct 5, 2021 2:47PM in SQL Language (MOSC) 3 commentsAnswered
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:

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