Verification of Table and Index Structure
Use
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
This type of verification locks the tables and indexes being checked in Oracle 8.1. Therefore, only use it when database activity is low. Starting with Oracle 9, tables and indexes are no longer locked.