Friday, 4 November 2011

Odblokowanie statystyk na tabelach oracle'a

select 'exec DBMS_STATS.UNLOCK_TABLE_STATS(''' || owner ||''' ,''' || table_name || '''); ' from dba_tab_statistics where stattype_locked is not null and owner not in ('SYS','SYSTEM');

No comments:

Post a Comment