Verification 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.


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.