Re: Corrupt block message in alert log

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Tue, 16 Jan 2001 15:24:12 GMT
Message-ID: <3A64679C.865AC0E@edcmail.cr.usgs.gov>

> ****** Persistents objects like table and indexes ********
> In the DBA_TABLES and DBA_INDEXES, you have the TABLESPACE_NAME column,
> and you have to check this objects with analyze :
>
> ANALYZE TABLE xxxx COMPUTE STATISTICS;
>
> ANALYZE INDEX xxxx COMPUTE STATISTICS;

Actually, you'll want to use the ANALYZE <TABLE|INDEX> object_name VALIDATE STRUCTURE; command.

HTH,
Brian

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================

Received on Tue Jan 16 2001 - 09:24:12 CST