sa_validate system procedure

Performs a checksum validation on all, or parts, of a database.

Syntax

sa_validate(
[ tbl_name
[, owner_name ] ]
)

Arguments

tbl_name – Use this optional CHAR(128) parameter to specify the name of a table or materialized view to validate. The default is NULL.
owner_name – Use this optional CHAR(128) parameter to specify an owner. When specified by itself, all tables and materialized views owned by the owner are validated. The default is NULL.

Privileges

You must have the VALIDATE ANY OBJECT system privilege.

Side effects

None

Remarks

Argument specified	Type of validation
None	All tables, materialized views, and indexes in the database are validated. The database itself is also validated, including checksum validation.
`tbl_name`	The specified table, or materialized view, and all of its indexes, that are owned by the current user are validated.
`owner_name`	All tables, materialized views, and indexes owned by the specified user are validated.
`tbl_name` and `owner_name`	The specified table, or materialized view, and all of its indexes, that are owned by the specified user are validated.

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.

Warning! 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.

Example

The following statement performs a validation of tables and materialized views owned by user DBA:

CALL sa_validate( owner_name = 'DBA' );