EXP-00008 EXP-00078 while exporting Spatial Index

(Doc ID 1240320.1)

Last updated on JULY 24, 2012

Applies to:

Oracle Spatial - Version 9.2.0.8 to 11.2
Information in this document applies to any platform.
***Checked for relevance on 23-Jul-2012***


Symptoms

Errors are encountered while exporting a Spatial Index:

<snip>
. exporting bitmap, functional and extensible indexes
EXP-00008: ORACLE error 0 encountered
ORA-00000: normal, successful completion
EXP-00078: Error exporting metadata for index <spatial_index>. Index creation will be skipped
<snip>
Export terminated successfully with warnings.


Running the following query may show that the index's DOMIDX_OPSTATUS is FAILED:

SELECT c.index_owner, c.index_name, c.table_owner, c.table_name,
       c.column_name, i.status, i.domidx_status, i.domidx_opstatus
FROM dba_indexes i, dba_ind_columns c
WHERE i.owner = '<owner>'
  AND i.index_name = '<spatial_index>
  AND i.owner = c.index_owner
  AND i.index_name = c.index_name;


Or running the following query shows that there is NO corresponding row for the Spatial Index found in ALL_SDO_GEOM_METADATA:

SELECT * FROM all_sdo_geom_metadata
WHERE owner = '<owner>';

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