invalid objects Etiketli Yazılar

Oracle – invalid objeleri listeleme

Select owner, object_type, substr(object_name,1,30) object_name, status
from dba_objects where status='INVALID' order by object_type;