ORA-06502 when running DBMS_STATS.GATHER_TABLE_STATS against a table name with special characters
(Doc ID 434025.1)
Last updated on APRIL 09, 2020
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
This problem can occur on any platform.
In a SAP environment, tables are named with special characters (for instance '/SDF/CMO_ERR_LOG').
Running DBMS_STATS.GATHER_TABLE_STATS against these kind of tables results in this error message
BEGIN DBMS_STATS.GATHER_TABLE_STATS(ownname=>'SAPPSE', tabname=>'/SDF/CMO_ERR_LOG',
method_opt=>'FOR ALL COLUMNS SIZE 254', degree=>4, cascade=>TRUE); END;
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.DBMS_STATS", line 10502
ORA-06512: at "SYS.DBMS_STATS", line 10516
ORA-06512: at line 1
For tablenames without special characters, it works fine. But can not change the tablenames.
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