ORA-39127 when exporting Oracle Text indexes

(Doc ID 2315554.1)

Last updated on OCTOBER 30, 2017

Applies to:

Oracle Text - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

What:
=============
ORA-39127: Unexpected error while calling local_str := SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_METADATA('.......
ORA-20000: Oracle Text Error:
ORA-06502: PL/SQL: numerical or value error
=============

Where:
=============
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters and Automatic Storage Management options
=============

When:
=============
EXP system/******** PARFILE=<.par file>

exp_p.par
DIRECTORY = <dir name>
JOB_NAME = exp_preadr
LOGFILE = exp_preadr.log
SCHEMAS = <schema name>
COMPRESSION = ALL
FLASHBACK_TIME = SYSTIMESTAMP
REUSE_DUMPFILES = YES
PARALLEL = 8
DUMPFILE = exp_preadr_%U.dmp
EXCLUDE = TABLE:"IN('TBL_IMAGE')"
=============

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