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.
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
Starting with Oracle 9i, tables and indexes are no longer locked.
However, if you option -v cascade_store then the indexes are still locked.