The ALL_ALL_TABLES view provides information about the tables accessible by the current user.

ownerTEXTUser name of the table’s owner.
schema_nameTEXTName of the schema in which the table belongs.
table_nameTEXTThe name of the table.
tablespace_nameTEXTName of the tablespace in which the table resides if other than the default tablespace.
statusCHARACTER VARYING (5)Included for compatibility only; always set to VALID.
temporaryTEXTY if the table is temporary; N if the table is permanent.