AnsweredAssumed Answered

SDE 10 Domain Index does not export ORA-39127

Question asked by geonetadmin on Aug 17, 2011
Latest reply on Apr 8, 2015 by mousaem
Original User: sherriekubis

Linux / RAC
SDE 10 SP 1

When performing either an expdp or exp to create a full export of the database, receive this error on the domain indexes:

ORA-39127: unexpected error from call to local_str := SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_METADATA('A18008_IX1','SDECREATOR','ST_DOMAIN_METHODS','SDE',,newblock,0)
ORA-20093: No ST_GRIDS supplied in PARAMETERS clause.
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 270
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 5280

After filing an SR with Oracle their response is that ESRI's custom domain index is not supported to expdp or exp.  We should drop the indexes before taking the export.

We do the export as a nightly safeguard and I see it as very risky to drop and recreate the domain indexes every night for this.  Any malfunction or error could cause an outage the next day for a maintenance reason.

Has anyone else encountered this?