The ALL_TABLES view provides the information on all user-defined tables.
| Parameter | Type | Description |
|---|---|---|
| owner | TEXT | The username of the owner to which the 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 where the table is located if this tablespace is not the default tablespace. |
| status | CHARACTER VARYING(5) | Indicates that whether the status of the table is valid. This parameter is supported for compatibility only. The value is VALID. |
| temporary | CHARACTER(1) |
|