Re: Data integrity checks against data corruption

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Tue, 31 Aug 1999 08:54:35 -0400
Message-ID: <7qgtnt$bnd$1@autumn.news.rcn.net>

Hi Joe,

Look up the ANALYZE command. It is used to both validate the structure of the database and to collect the statistics used by the Cost Based Optimizer. Basic syntax validating a table structure is:

ANALYZE TABLE <table_name> VALIDATE STRUCTURE CASCADE;

It doesn't matter how bulletproof your RDBMS is this is something you need -- just in case. I have had to use it when rebuilding tables and indexes that were corrupted by hardware problems.

Regards
Jerry Gitomer

Joe F wrote in message ...
>Hi I'm new to Oracle, I've been using SQL server, and I'd like
to ask, if
>there are ways of performing, data integrity checks to check for
data/ index
>corruption? (dbcc is used in SQL server)
>
>Perhaps Oracle is different and doesn't need such checks.
>
>Can you please help?
>
>Many thanks
>Joe
>
>
Received on Tue Aug 31 1999 - 07:54:35 CDT