Re: Oracle Newbie Questions...for you experts.

From: Graham C Thornton <graham.thornton_at_ln.ssw.abbott.com>
Date: Wed, 7 Apr 1999 13:00:30 -0500
Message-ID: <7eg6gb$b910@news.abbott.com>

Thomas Kyte wrote in message <370689ac.9017276_at_192.86.155.100>...
>A copy of this was sent to Gregory Carter <gcarter_at_digivis.com>
>(if that email address didn't require changing)
>On Fri, 26 Mar 1999 08:09:29 +0000, you wrote:
>
>>#1 Does anyone know how to check an Oracle 8 database with a script or
>>something that would insure its integrity is intact?
>>
>
>there is the command:
>
>SQL> analyze table emp validate structure cascade;
>Table analyzed.
>
>that checks the table and related indexes for structural correctness.
>

You might also find the following useful...

SQL>exec dbms_utility.compile_schema( '<SCHEMA_NAME>' );

The query the DBA_OBJECTS table for any objects owned by that schema that have a status of invalid.

Graham. Received on Wed Apr 07 1999 - 13:00:30 CDT