SYS.DBA_TABLES

The SYS.DBA_TABLES view describes all tables in the database. See SYS.ALL_TABLES for column descriptions.