Conditions to check the database

From: <laulau823_at_my-deja.com>
Date: 2000/04/30
Message-ID: <8ehfgu$dnn$1@nnrp1.deja.com>#1/1

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:

check all the tables have the primary key (by dba_constraints)
check the objects are valid (by dba_objects)
check the foreign key constraints (by dba_constraints)

Thanks,
David

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Apr 30 2000 - 00:00:00 CDT