USER_TABLES

The USER_TABLES view provides information about the relational tables owned by the current user.

Column name	Data type	Description
TABLE_NAME	VARCHAR2(30)	The name of the table. Always INLINE.
STATUS	VARCHAR2(8)	Specifies whether the table is UNUSABLE or VALID after a failed DROP TABLE operation. Always INLINE, NOT NULL.
LOGGING	VARCHAR2(3)	Specifies whether changes to the table are logged (YES) or not (NO). Always INLINE, NOT NULL.
NUM_ROWS	NUMBER	The number of rows. Always NULL, INLINE.
PARTITIONED	VARCHAR2(3)	Specifies whether the table is partitioned (YES) or not (NO). Always NO, INLINE, NOT NULL.
TEMPORARY	VARCHAR2(1)	Specifies whether the table is temporary (Y) or permanent (N). Always NOT NULL, INLINE.
DURATION	VARCHAR2(8)	The duration of a temporary table. The possible values are: SYS$SESSION - Rows are preserved for the duration of the session. SYS$TRANSACTION - Rows are deleted after COMMIT. NULL - The table is not a temporary table. Always INLINE.
COMPRESSION	VARCHAR2(3)	The status of column-based compression. The possible values are: ENABLED DISABLED Always INLINE, NOT NULL.
COMPRESS_FOR	NUMBER	Specifies whether compression is enabled (QUERY HIGH) or disabled (NULL). Always INLINE.