The ALL_TABLES view provides information on all user-defined tables.

ownerTEXTUser name of the table’s owner.
schema_nameTEXTName of the schema in which the table belongs.
table_nameTEXTName of the table.
tablespace_nameTEXTName of the tablespace in which the table resides if other than the default tablespace.
statusCHARACTER VARYING(5)Whether or not the state of the table is valid. Currently, Included for compatibility only; always set to VALID.
temporaryCHARACTER(1)Y if this is a temporary table; N if this is not a temporary table.