Last updated on JULY 24, 2012
Applies to:Oracle Spatial - Version 126.96.36.199 to 11.2
Information in this document applies to any platform.
***Checked for relevance on 23-Jul-2012***
Errors are encountered while exporting a Spatial Index:
. 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
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>';
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms