terça-feira, 27 de outubro de 2009

Objectos invalidos

Select count(*) from dba_objects where status = 'INVALID';
Select count(*) from dba_indexes where status = 'UNUSABLE';
Select count(*) from dba_triggers where status = 'DISABLED';
Select owner,object_name,object_type from dba_objects where status = 'INVALID';
Select owner,index_name from dba_indexes where status = 'UNUSABLE';
Select owner,trigger_name from dba_triggers where status = 'DISABLED';

Sem comentários:

Enviar um comentário