Good day.
I have suddenly started getting an ORA-01722 invalid number error when attempting to gather stats on one particular table.
SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS(OWNNAME => 'EMIS', TABNAME => 'CAREER_TECH', GRANULARITY => 'ALL', CASCADE => TRUE, ESTIMATE_PERCENT => 100, DEGREE => 4);
BEGIN DBMS_STATS.GATHER_TABLE_STATS(OWNNAME => 'EMIS', TABNAME => 'CAREER_TECH', GRANULARITY => 'ALL', CASCADE => TRUE, ESTIMATE_PERCENT => 100, DEGREE => 4); END;
*
ERROR at line 1:
ORA-12801: error signaled in parallel query server P004
ORA-01722: invalid number
ORA-06512: at "SYS.DBMS_STATS", line 24281
ORA-06512: at "SYS.DBMS_STATS", line 24332
ORA-06512: at line 1
The only way I can get it to successfully complete is by setting ESTIMATE_PERCENT to DBMS_STATS.AUTO_SAMPLE_SIZE in the table and then not indicating a value for ESTIMATE_PERCENT in the command.
CAREER_TECH is the only table that returns this error. It is not an unusual table in the database, it is partitioned and subpartitioned by certain values just like many of our other tables.
Has anyone encountered this problem before?