Skip Headers
Oracle® TimesTen In-Memory Database SQL Reference
Release 11.2.1

Part Number E13070-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

SYS.TTABLES

The TTABLES table stores information about temporary table instances associated with active sessions, including the name, the owner, the number of columns, the size of a row and the primary key (if any).

Specific column information is stored in the COLUMNS table.

Columns

Column name Type Descriptions
TBLNAME TT_CHAR (31) NOT NULL Table name.
TBLOWNER TT_CHAR (31) NOT NULL Name of user who owns the table.
OWNER TT_INTEGER NOT NULL Owner of table:

0 - TimesTen system table.

1 - User table.

NUMVARY TT_SMALLINT NOT NULL Number of varying-length columns in table.
NUMNULL TT_SMALLINT NOT NULL Number of nullable columns in table.
NUMCOLS TT_SMALLINT NOT NULL Number of columns in table.
LENGTH TT_INTEGER NOT NULL for 32-bit systems;

TT_BIGINT NOT NULL for 64-bit systems

Length of in-line portion of each row.
TBLID TT_INTEGER NOT NULL for 32-bit systems;

TT_BIGINT NOT NULL for 64-bit systems

TimesTen identifier for table.
NUMTUPS TT_INTEGER NOT NULL for 32-bit systems;

TT_BIGINT NOT NULL for 64-bit systems

Table cardinality. This value is precise only when no INSERT or DELETE transactions are active. The value includes uncommitted inserts, but not uncommitted deletes. Consequently, the value of this field may be larger than the actual table cardinality.
MAXTUPS TT_INTEGER NOT NULL for 32-bit systems;

TT_BIGINT NOT NULL for 64-bit systems

Maximum table cardinality.
PRIMCNT TT_SMALLINT NOT NULL Number of columns in primary key (0 if none).
PRIMCOLS BINARY (32) NOT NULL Array of 2-byte integer column numbers of primary key, mapped to binary.
CACHEFLAG BINARY(1) NOT NULL 1 - if the table is in a cache group, 0 otherwise.
XLAFLAG BINARY(1) NOT NULL If set, updates to this table should be transmitted to the transaction log API.
PXLAFLAG BINARY(1) NOT NULL If set, indicates that persistent XLA has been enabled for this particular user table.
CACHEGROUP TT_INTEGER NOT NULL for 32-bit systems;

TT_BIGINT NOT NULL for 64-bit systems

Id of cache group that this table belongs to.
MVID TT_INTEGER NOT NULL for 32-bit systems;

TT_BIGINT NOT NULL for 64-bit systems

If the table is a VIEW, indicates the ID of the associated row in the VIEWS system table
MVIDS TT_VARCHAR(1024) NOT INLINE If the table is a VIEW detail table, indicates the ID of the array of the Ids of the rows in the VIEWS system table of the materialized views that reference this detail table.
PERMLTBLID TT_INTEGER NOT NULL The associated permanent table's ID.
REPNUMKEYCOLS TT_SMALLINT NOT NULL Number of columns in the replication key described by REPKEYCOLS
REPTSCOLNUM TT_SMALLINT NOT NULL Column number of the column used for replication's timestamp-based conflict checking.
REPRETURNSERVICE TT_CHAR (1) NOT NULL Return service for this subscriber with respect to this replication element:

'C' - RETURN COMMIT

'R' - RETURN RECEIPT

'2' - RETURN TWOSAFE

'\0' - NO RETURN services

REPRETURNBY

REQUEST

BINARY (1) NOT NULL 0 - RETURN services are provided unconditionally

1 - RETURN services are provided only BY REQUEST. This field is ignored if REPRETURNSERVICE = '\0'

REPUSERID TT_BIGINT NOT NULL User-defined identifier for table (set with -ttSetUserTableID built-in function).
REPKEYCOLS BINARY (32) NOT NULL Column numbers used by replication for unique identification of a row.

(an array of 2-byte integers, mapped to binary)

REPACCESS TT_CHAR (1) NOT NULL The access restrictions imposed by replication:

'-' - no access permitted

's'- may be read by read-only (SELECT) transactions

'r' -  may be read by updating transactions

'w' - may be updated

w => r and r => s.

REPTSUPDATERULE TT_CHAR (1) NOT NULL The rule for maintaining the TS_COLUMN for a timestamp-based conflict detector:

'\0' - rule not defined

'U' - BY USER

'S' - BY SYSTEM (default)