Re: Conditions to check the database

        ANALYZE TABLE <table name> VALIDATE STRUCTURE CASCADE;

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 4/30/00, 9:21:27 AM, laulau823_at_my-deja.com wrote regarding Conditions to check the database:

> Hello all,

> Could anyone suggest conditions to check the current objects in
> Oracle database (Oracle 8 in Solaris) have the potential errors (based
 

> on the data directory)? For example, I have raised the following
> conditions:
 

> 1) check all the tables have the primary key (by dba constraints)
> 2) check the objects are valid (by dba objects)
> 3) check the foreign key constraints (by dba constraints)
 

> Thanks,
> David

> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon May 01 2000 - 00:00:00 CDT