Re: How to check corruption in system tablespace

In our last gripping episode ashish25_at_my-deja.com wrote:
> Hi,
> How to check that no data dictionary table or index is corrupted?
> I ran dbv on system tablespace datafile and that came OK.
> Thanks,
> Ashish
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

As a start:

select owner, object_name, status
from dba_objects

where object_type = 'TABLE'
and owner like 'SYS%'
and status <> 'VALID';

You can query for indexes as well.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.