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)
  • Y: indicates that the table is a temporary table.
  • N: indicates that the table is not a temporary table.