ORA-01847 where try use DBMS_STATS.GATHER_TABLE_STATS on specific table
Hi all,
When I try execute command for manual DBMS_STATS, got this error:
BEGIN DBMS_STATS.GATHER_TABLE_STATS('MICROMEDICAO','HIDROMETRO_INST_HIST',estimate_percent => 30,cascade=>TRUE, method_opt=>'for all indexed columns size 1'); END;
ERRO na linha 1:
ORA-01847: dia do mês deve estar entre 1 e o último dia do mês
ORA-06512: em "SYS.DBMS_STATS", line 20337
ORA-06512: em "SYS.DBMS_STATS", line 20360
ORA-06512: em line 1
I dont exatly treat and how happen,probably anything wrong with data type on this table, because all the others no have problem.
How to find wrong registry on table can be cause this error?
BEGIN DBMS_STATS.GATHER_TABLE_STATS('MICROMEDICAO','HIDROMETRO_INST_HIST',estimate_percent => 30,cascade=>TRUE, method_opt=>'for all indexed columns size 1'); END;
ERRO na linha 1:
ORA-01847: dia do mês deve estar entre 1 e o último dia do mês
ORA-06512: em "SYS.DBMS_STATS", line 20337
ORA-06512: em "SYS.DBMS_STATS", line 20360
ORA-06512: em line 1
I dont exatly treat and how happen,probably anything wrong with data type on this table, because all the others no have problem.
How to find wrong registry on table can be cause this error?
0