Today, I get the next error;
ORA-20006: Unable to restore statistics , statistics history not available
I was executing the next package;
execute dbms_stats.restore_table_stats (‘SIEBELA’,’S_EVT_ACT’,’25-DEC-14 12.00.00.00000 PM +02:00′);
The problem is that dba_tab_stats_history table have not rows for this date. There is not statistics for this time.
HTH – Antonio NAVARRO