ORA-20006 Error

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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s