USER_ALL_TABLES lists all tables owned by the current user.
Columns
| Column | Type | Description |
|---|---|---|
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 resides. Populated only when the tablespace is not the default tablespace. |
status | CHARACTER VARYING(5) | Included for compatibility only. Always set to VALID. |
temporary | TEXT | Y if the table is a temporary table; N if the table is a permanent table. |