利用hcheck检查数据字典不一致

Oracle metalink提供了一个脚本用于分析数据库数据字典不一致。
Usage:

$ sqlplus

SQL*Plus: Release 9.2.0.2.0 - Production on Mon Nov 11 12:00:06 2002

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Enter user-name: / as sysdba

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.2.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.2.0 - Production 

SQL> set serveroutput on

SQL> spool outputfile

SQL> execute hcheck.full    
    

Instructions:

1. Connect as SYS schema in sqlplus

2. Create package hOut as described in Note:101468.1

3. Create package hcheck in SYS schema (Refer the attachment under SCRIPT to Create package hcheck 

4. spool outputfile

5. execute hcheck.full

6. Output will go to the spool file and the session trace file.
   The script will report various dictionary related issues
   which may or may not be a problem - Any problems reported
   should be reviewed by an experienced support analyst as some
   reported "problems" may be normal and expected.


以下为oracle 9204 for linux输出结果

引用

SQL> set serveroutput on
SQL>  spool outputfile
SQL> execute hcheck.full    
HCheck Version 8i-11/1.70

Problem:  SOURCE$ for OBJ# not in OBJ$ - Bug:3532977 ?
SOURCE$ has 127 rows for 6 OBJ# values not in OBJ$

Warning:  OBJECT name clashes with SCHEMA name - Bug:2894111 etc..
Schema=TEST Object=TEST.TEST (TABLE)

Found 1 potential problems and 1 warnings
Contact Oracle Support with the output
to check if the above needs attention or not

PL/SQL procedure successfully completed.