DBA_TABLES is a system view that returns metadata for all tables in the database.
Column reference
| Column | Type | Description |
|---|---|---|
owner | TEXT | The username of the table owner. |
schema_name | TEXT | The name of the schema that contains the table. |
table_name | TEXT | The name of the table. |
tablespace_name | TEXT | The name of the tablespace where the table is located, if the tablespace is not the default tablespace. |
status | CHARACTER VARYING(5) | Included for compatibility only. Always VALID. |
temporary | CHARACTER(1) | Y if the table is a temporary table. N if the table is a permanent table. |