Oracle Error Message
ORA-64148: Cannot complete nonblocking alter index operation.
Reason for the Error
NONBLOCKING COMPLETE is only allowed for XMLIndex that is being modified using NONBLOCKING ADD_GROUP or ADD_COLUMN and there are no pending rows left.
Solution
Call DBMS_XMLINDEX.PROCESS_PENDING to finish pending work.