LLI Wiki — My Digital Knowledge Base

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.

Mastodon LLIMastodon SocialFosstodon