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 |
|