Show TOC

Verification of Table and Index StructureLocate this document in the navigation 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

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.