Oracle: check the data dictionary with hcheck.sql
Run hcheck.sql to detect known Oracle data dictionary problems.
hcheck.sql is an Oracle script that looks for known problems in a database's data dictionary. It is run from SQL*Plus.
SQL> @hcheck.sql
The script is described and available from Oracle-Base: hcheck.sql. If a copy already exists in $ORACLE_HOME/rdbms/admin/, call it with @$ORACLE_HOME/rdbms/admin/hcheck.sql; otherwise place it in SQL*Plus's current directory.
Run it with an account that has administrative privileges (for example SYSDBA) and review the output before any corrective action.