Function documentationVerification of Table and Index Structure

 

This section describes how you can use BRCONNECT for the Oracle database to check the internal structure of table and index blocks. This is an alternative to DBVERIFY. However, the scope of the checks is not the same.

Example

To check the structure of all tables and their indexes in the tablespace PSAPBTABD, enter the following command:

brconnect -u / -c -f stats -t psapbtabd -v cascade

Caution Caution

Starting with Oracle 9i, tables and indexes are no longer locked.

However, if you option —v cascade_store then the indexes are still locked.

End of the caution.