SYS.ALL_TABLES

The ALL_TABLES view describes all tables accessible to the current user. The column names and data types are the same as the Oracle Database. TimesTen returns NULL for some columns that are not supported in TimesTen. You should ignore such columns. See the Description column in the Columns table.

Related views

• SYS.DBA_TABLES describes all tables in the database.

• SYS.USER_TABLES describes all tables in the database that are owned by the current user.

Columns

Column name	Type	Description
OWNER	VARCHAR2(30) INLINE	Owner of the table
TABLE_NAME	VARCHAR2(30) INLINE	Name of the table
TABLESPACE_NAME	VARCHAR2(30) INLINE	Unused (Column unused by TimesTen. Ignore value.)
CLUSTER_NAME	VARCHAR2(30) INLINE	Unused (Column unused by TimesTen. Ignore value.)
IOT_NAME	VARCHAR2(30) INLINE	Unused (Column unused by TimesTen. Ignore value.)
STATUS	VARCHAR2(8) INLINE NOT NULL	If a previous DROP TABLE operation failed, indication of whether the table is UNUSABLE or VALID
PCT_FREE	NUMBER	Unused (Column unused by TimesTen. Ignore value.)
PCT_USED	NUMBER	Unused (Column unused by TimesTen. Ignore value.)
INI_TRANS	NUMBER	Unused (Column unused by TimesTen. Ignore value.)
MAX_TRANS	NUMBER	Unused (Column unused by TimesTen. Ignore value.)
INITIAL_EXTENT	NUMBER	Unused (Column unused by TimesTen. Ignore value.)
NEXT_EXTENT	NUMBER	Unused (Column unused by TimesTen. Ignore value.)
MIN_EXTENTS	NUMBER	Unused (Column unused by TimesTen. Ignore value.)
MAX_EXTENTS	NUMBER	Unused (Column unused by TimesTen. Ignore value.)
PCT_INCREASE	NUMBER	Unused (Column unused by TimesTen. Ignore value.)
FREELISTS	NUMBER	Unused (Column unused by TimesTen. Ignore value.)
FREELIST_GROUPS	NUMBER	Unused (Column unused by TimesTen. Ignore value.)
LOGGING	VARCHAR2(3) INLINE NOT NULL	YES if changes to the table are logged NO if changes to the table are not logged
BACKED_UP	VARCHAR2(1) INLINE	Unused (Column unused by TimesTen. Ignore value.)
NUM_ROWS	NUMBER	Number of rows
BLOCKS	NUMBER	Unused (Column unused by TimesTen. Ignore value.)
EMPTY_BLOCKS	NUMBER	Unused (Column unused by TimesTen. Ignore value.)
AVG_SPACE	NUMBER	Unused (Column unused by TimesTen. Ignore value.)
CHAIN_CNT	NUMBER	Unused (Column unused by TimesTen. Ignore value.)
AVG_ROW_LEN	NUMBER	Unused (Column unused by TimesTen. Ignore value.)
AVG_SPACE_FREELIST_BLOCKS	NUMBER	Unused (Column unused by TimesTen. Ignore value.)
NUM_FREELIST_BLOCKS	NUMBER	Unused (Column unused by TimesTen. Ignore value.)
DEGREE	VARCHAR2(10) INLINE	Unused (Column unused by TimesTen. Ignore value.)
INSTANCES	VARCHAR2(10) INLINE	Unused (Column unused by TimesTen. Ignore value.)
CACHE	VARCHAR2(5) INLINE	Unused (Column unused by TimesTen. Ignore value.)
TABLE_LOCK	VARCHAR2(8) INLINE	Unused (Column unused by TimesTen. Ignore value.)
SAMPLE_SIZE	NUMBER	Unused (Column unused by TimesTen. Ignore value.)
LAST_ANALYZED	DATE	Unused (Column unused by TimesTen. Ignore value.)
PARTITIONED	VARCHAR2(3) INLINE NOT NULL	Value of NO TimesTen does not support partitioned tables.
IOT_TYPE	VARCHAR2(12) INLINE	Unused (Column unused by TimesTen. Ignore value.)
TEMPORARY	VARCHAR2(1) INLINE NOT NULL	Y if temporary table N otherwise
SECONDARY	VARCHAR2(1) INLINE NOT NULL	Unused Value returned is N. (Column unused by TimesTen. Ignore value.)
NESTED	VARCHAR2(3) INLINE NOT NULL	Unused Value returned is NO. TimesTen does not support nested tables. (Column unused by TimesTen. Ignore value.)
BUFFER_POOL	VARCHAR2(7) INLINE NOT NULL	Unused Value returned is DEFAULT. (Column unused by TimesTen. Ignore value.)
FLASH_CACHE	VARCHAR2(7) INLINE NOT NULL	Unused Value returned is DEFAULT. (Column unused by TimesTen. Ignore value.)
CELL_FLASH_CACHE	VARCHAR2(7) INLINE NOT NULL	Unused Value returned is DEFAULT. (Column unused by TimesTen. Ignore value.)
ROW_MOVEMENT	VARCHAR2(8) INLINE NOT NULL	Unused Value returned is DISABLED. (Column unused by TimesTen. Ignore value.)
GLOBAL_STATS	VARCHAR2(3) INLINE NOT NULL	Unused Value returned is NO. (Column unused by TimesTen. Ignore value.)
USER_STATS	VARCHAR2(3) INLINE	Unused (Column unused by TimesTen. Ignore value.)
DURATION	VARCHAR2(15) INLINE	Duration of a temporary table If value returned is SYS$SESSION, rows are preserved for the duration of the session. If value returned is SYS$TRANSACTION, rows are deleted after COMMIT. If value returned is NULL, table is not a temporary table.
SKIP_CORRUPT	VARCHAR2(8) INLINE NOT NULL	Unused Value returned is DISABLED. (Column unused by TimesTen. Ignore value.)
MONITORING	VARCHAR2(3) INLINE NOT NULL	Unused Value returned is NO. (Column unused by TimesTen. Ignore value.)
CLUSTER_OWNER	VARCHAR2(30) INLINE	Unused (Column unused by TimesTen. Ignore value.)
DEPENDENCIES	VARCHAR2(8) INLINE NOT NULL	Unused Value returned is DISABLED. (Column unused by TimesTen. Ignore value.)
COMPRESSION	VARCHAR2(8) INLINE NOT NULL	Status of column-based compression (ENABLED or DISABLED)
COMPRESS_FOR	VARCHAR2(12) INLINE	QUERY HIGH if compression is enabled NULL otherwise
DROPPED	VARCHAR2(3) INLINE NOT NULL	Unused Value returned is NO. (Column unused by TimesTen. Ignore value.)
READ_ONLY	VARCHAR2(3) INLINE	Unused Value returned is NULL. (Column unused by TimesTen. Ignore value.)
SEGMENT_CREATED	VARCHAR2(3)INLINE NOT NULL	Unused Value returned is YES. (Column unused by TimesTen. Ignore value.)
RESULT_CACHE	VARCHAR2(7) INLINE NOT NULL	Unused Value returned is DEFAULT. (Column unused by TimesTen. Ignore value.)