Re: Check integrity of database !!!

On Wed, 31 Oct 2001 09:47:32 +0100, "Đuro Dretvić" <Djuro.Dretvic_at_Infodom.hr> wrote:

>Dear all
>
>Question:
>
>How to check database integrity on RDBMS 8.1.7 installed on Windows NT
>2000 operating system.
>
>I want to check is there coruption on data block etc, and I want to check
>complete database.
>Are there any tool to perform that operation.
>
>Thanks.
>
>Regards D.
>

For physical integrity you can use dbverify. For datadictionary integrity: unless you changed the underlying tables manually you can rest assured the dictionary will be correct.

For database integrity on logical level: Oracle can not check. You need a data-modeling tool to do this like Designer. The dictionary only contains the *live* situation, and it doesn't have a clue about what *should* be there.
Nor it doesn't have a clue whether you specified *all* your constraints correctly, or any constraints at all. If you have all the correct constraints, and they are enabled (I frequently see people defining constraints and disabling/enabling them) you can rest assured the integrity of your database isn't compromised.
In all other cases you obviously need to write your own code.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Oct 31 2001 - 03:10:32 CST