Re: How to check corruption in system tablespace

From: <jdarrah_co_at_my-deja.com>
Date: Sat, 18 Nov 2000 00:48:19 GMT
Message-ID: <8v4jki$hbj$1@nnrp1.deja.com>

This comes from Oracle Note# 96117.1

Run the following as sys then run the output

    set head off feedback off pagesize 500 echo off     spool /tmp/analyze_objects.sql
    select 'ANALYZE TABLE "'||table_name||'" VALIDATE STRUCTURE CASCADE;'
    from dba_tables
    where tablespace_name='SYSTEM'
    and owner='SYS';

    select 'ANALYZE CLUSTER "'||cluster_name||'" VALIDATE STRUCTURE CASCADE;'
    from dba_clusters
    where tablespace_name='SYSTEM'
    and owner='SYS';
    spool off

In article <8v463o$647$1_at_nnrp1.deja.com>, 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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 17 2000 - 18:48:19 CST