29861, 00000, "domain index is marked LOADING/FAILED/UNUSABLE" // *Cause: An attempt has been made to access a domain index that is // being built or is marked failed by an unsuccessful DDL // or is marked unusable by a DDL operation. // *Action: Wait if the specified index is marked LOADING // Drop the specified index if it is marked FAILED // Drop or rebuild the specified index if it is marked UNUSABLE.
user13069161 wrote:Hi,you have to need drop and create(or rebuild) this index as
I know this information, but i don't know how to "wait" or "rebuild" or "drop".
Can you tell me resolve this step by step?
By the way, i never use any oracle software.
then create again
select dbms_metadata.get_ddl('INDEX',INDEX_NAME) from dba_indexes where index_name='PK_ACCOUNT'; --keep this result drop index PK_ACCOUNT;