This error can occur when processing Database_Statistics if there is a database table name longer than 30 characters. We have seen this issue when customers have created custom tables with table names greater than 30 characters in length in the avuser schema.

Resolution

To determine if this is the issue, as avuser, run the below query to find the list of all tables in the avuser schema and their table name lengths:

select table_name, length(to_char(table_name)) as table_length from user_tables order by 2 desc;

If you find that there are any custom tables with a table name length greater than 30 characters, then any one of the below options maybe used to resolve the issue:

Drop the custom table if the table is no longer used. Run this command as avuser.

DROP TABLE <TABLE_NAME>;

Rename the table name and make sure the length of the new table name is less than 30 characters. Run this command as avuser.

ALTER TABLE <TABLE_NAME> RENAME TO <NEW_TABLE_NAME>;

Notes

When you rename an Oracle table you must be aware that Oracle does not update applications (HTML-DB, PL/SQL that referenced the old table name) and PL/SQL procedures may become invalid. So please make sure any reference of the old table name is updated.