Verifying Table Formats in Oracle

To verify table formats in Oracle:

1. Log on to the database as the owner of the tablespace that contains the table in question.

2. Run this SQL query:

   Describe tableowner.tablename
   

   where tableowner.tablename is the appropriate table owner name and table name.

   The query returns a list of all fields in the file in the specified tablespace.

3. Using the information above, verify that the number of columns and the record counts are consistent between the log file and the actual table.

   The information in the log file should be correct.