My Oracle Support Banner

EXPDP of Text Index Fails With ORA-39127, ORA-20000, ORA-06502: PL/SQL: numeric or value error: character string buffer too small (Doc ID 2998942.1)

Last updated on FEBRUARY 01, 2024

Applies to:

Oracle Text - Version 19.3.0.0.0 to 21c [Release 19c to 21c]
Information in this document applies to any platform.

Symptoms

Export of a MULTI_COLUMN_DATASTORE Text index, TESTUSER.TESTTAB_CTX in the example below, fails with errors:

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Starting "SYSTEM"."SYS_EXPORT_TABLE_01":  system/******** directory=dumpdir tables=testuser.testtab dumpfile=testtab.dmp logfile=exp_testtab.log reuse_dumpfiles=yes
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39127: unexpected error from call to local_str := SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_METADATA('TESTTAB_CTX','TESTUSER','TEXTINDEXMETHODS','CTXSYS','19.00.00.00.00',newblock,0,-1,'')
ORA-20000: Oracle Text error:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 283
ORA-06512: at "SYS.DBMS_ODCI", line 251
ORA-06512: at "CTXSYS.DRUE", line 186
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 803
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SQL", line 1721
ORA-06512: at "SYS.DBMS_ODCI", line 242
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SQL", line 1721
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 259
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 283
ORA-06512: at "SYS.DBMS_ODCI", line 251
ORA-06512: at "CTXSYS.DRUE", line 186
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 803
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SQL", line 1721
ORA-06512: at "SYS.DBMS_ODCI", line 242
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SQL", line 1721
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 259
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 10501
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95

Processing object type TABLE_EXPORT/TABLE/INDEX/DOMAIN_INDEX/INDEX
. . exported "TESTUSER"."TESTTAB"                            0 KB       0 rows
Master table "SYSTEM"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_TABLE_01 is:
  /u01/oracle/mydumpdir/testtab.dmp
Job "SYSTEM"."SYS_EXPORT_TABLE_01" completed with 1 error(s) at Thu Jan 18 20:48:16 2024 elapsed 0 00:00:06



Running the CTX_REPORT.CREATE_INDEX_SCRIPT procedure to generate the DDL of the Text index fails with the same ORA-06502 character string buffer too small error:

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.