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 JULY 20, 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
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 |