I faced with that error during export process on Oracle 12c RAC database
Complete error message is:
ORA-39127: unexpected error from call to local_str := SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_METADATA(‘INDEX_NAME_HERE’,’SCHEMA_NAME_HERE’,’TEXTINDEXMETHODS’,’CTXSYS’,12.01.00.02.00,newblock,0) ORA-20000: Oracle Text error: DRG-10502: index SCHEMA_NAME_HERE”.”INDEX_NAME_HERE does not exist ORA-06512: at “SYS.DBMS_EXPORT_EXTENSION”, line 274 ORA-06512: at line 1 ORA-06512: at “SYS.DBMS_METADATA”, line 9524
After investigate issue I found ORA-39127 ORA-20000 DRG-10502 Errors when Doing EXPDP (Doc ID 979047.1)
So here is the steps:
1.What is cause for that error? Here is the answer:
The errors are thrown because the domain index has status FAILED, visible in USER_/DBA_INDEXES view, and no entry exists in Text data dictionary, ctxsys schema.
ONLY metadata of VALID domain indexes are exported.
- Use below query to see exact status of index
select index_name, status, domidx_status, domidx_opstatus from dba_indexes where index_type = ‘DOMAIN’ and domidx_opstatus = ‘FAILED’;
Export is fail because domidx_opstatus in failed status.
- You mat try to drop and re-create index or if the indexes are not used then drop them.
In my case even i re-create index domidx_opstatus still in failed status. So I checked latest usage of index. It seems it doesnt access than i decided to drop index.
Yorum bırakın
Comments feed for this article