tbl_name
Use this optional VARCHAR(128) parameter to specify the name of a table or materialized view to validate.
owner_name
Use this optional VARCHAR(128) parameter to specify an owner. When specified by itself, all tables and materialized
views owned by the owner are validated.
All tables, materialized views, and indexes in the database are validated. The database itself is also validated, including
checksum validation.
owner_name
All tables, materialized views, and indexes owned by the specified user are validated.
tbl_name
The specified table, or materialized view, and all of its indexes, that are owned by the current user are validated.
owner_name and tbl_name
The specified table, or materialized view, and all of its indexes, that are owned by the specified user are validated.
The values for tbl_name and owner_name are strings and must be enclosed in quotes.
The procedure returns a single column named Messages. Errors returned during validation appear in the column. If validation
succeeds without error, the column contains No error detected.
Caution
Validating a table or an entire database should be performed while no connections are making changes to the database; otherwise,
errors may be reported indicating some form of database corruption even though no corruption actually exists.
Syntax