Export Fails On Function-Based Spatial Indexes With: Exp-8 Ora-6502 Ora-6512 Exp-78 (Doc ID 363196.1)

Last updated on JULY 23, 2012

Applies to:

Oracle Spatial - Version: 9.2.0.7 to 11.1.0.6 - Release: 9.2 to 11.1
Information in this document applies to any platform.
***Checked for relevance on 23-Jul-2012***

Symptoms

Both full and user-level exports fail on function-based Spatial indexes with the following errors:

...
. exporting bitmap, functional and extensible indexes
EXP-00008: ORACLE error 6502 encountered
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 261
ORA-06512: at line 1
EXP-00078: Error exporting metadata for index IO_GEOMETRY_LONG_LAT_SIDX. Index creation will be
skipped
EXP-00008: ORACLE error 6502 encountered
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 261
ORA-06512: at line 1
EXP-00078: Error exporting metadata for index LOC_LONG_LAT_SIDX. Index creation will be skipped
. exporting posttables actions
...
Export terminated successfully with warnings.

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