EXPDP Raises EXP-00078 For A Spatial Index, Rebuilding The Index Fails With ORA-13209 (Doc ID 1418651.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 10.2.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 03-Oct-2013**

Symptoms

Expdp fails with
EXP-00078: Error exporting metadata for index my_index. Index creation will be skipped
for a Spatial index, while attempting to rebuild the index with the statement

alter index my_index rebuild;


raises the error
ORA-29858: error occurred in the execution of ODCIINDEXALTER routine
ORA-29400: data cartridge error
ORA-01403: no data found
ORA-13249: internal error in Spatial index: [mdidxrbd]
ORA-13209: internal error while reading SDO_INDEX_METADATA table
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 266

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms