Re: Check for database corruption?

Try run

select * from all_objects where status='INVALID'

and spool the result to a file, then mail this file to you every night.So that we can read the result every morning.

Hope this helps.

Guang

In article <90rjtm$6pc$1_at_nnrp1.deja.com>,   Aaron <asentell_at_my-deja.com> wrote:
> I'm fairly new to Oracle but not to database administration. As a
> Sybase DBA, I made sure that I ran a database consistency check on all
> my production databases at least once a week. From what I've read and
> seen thus far, however, this same level of precaution is not necessarily
> required for Oracle, although I'm quite sure this is not Oracle's
> official position.
>
> I want to get some input from DBAs who are out there in the trenches and
> have experience with this. Is it worth the time to run "analyze
> table...verify structure cascade" on a regular basis in production
> databases? Note that we perform a full export every night in addition
> to database backups.
>
> Thank you,
> Aaron
>
> 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 Dec 08 2000 - 22:07:17 CST