Re: How to check corruption in system tablespace

Hi ,
  As per that note I can analyze Sys tables but as far as I remeber Oracle advices not to analyze any sys tables.

   If I do this analyze for checking corrpution will it impact anything??
Thanks,
Ashish

In article <8v4jki$hbj$1_at_nnrp1.deja.com>,   jdarrah_co_at_my-deja.com wrote:
> 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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Nov 18 2000 - 07:44:42 CST