The DBA_ALL_TABLES view provides the information about all tables in the database.
| Parameter | Type | Description |
|---|---|---|
| owner | TEXT | The username of the owner to which a table belongs. |
| schema_name | TEXT | The name of the schema to which the table belongs. |
| table_name | TEXT | The name of the table. |
| tablespace_name | TEXT | The name of the tablespace in which the table is located if this tablespace is not the default tablespace. |
| status | CHARACTER VARYING(5) | This parameter is supported for compatibility only. The value is VALID. |
| temporary | TEXT |
|