where can I find meaings of each column in sys.tables
Command> host ttversion
TimesTen Release 11.2.2.2.0 (64 bit Linux/x86_64) (tt1122:53396) 2011-12-23T09:26:28Z
Instance admin: tttest
Instance home directory: /timesten/TimesTen/tt1122
Group owner: tttest
Daemon home directory: /timesten/TimesTen/tt1122/info
PL/SQL enabled.
Command> desc sys.tables;
System table SYS.TABLES:
Columns:
SYS26 TT_BIGINT NOT NULL
*TBLNAME TT_CHAR (31) NOT NULL
*TBLOWNER TT_CHAR (31) NOT NULL
SYS2 TT_SMALLINT NOT NULL
SYS18 TT_BIGINT NOT NULL
SYS1 TT_BIGINT NOT NULL
OWNER TT_INTEGER NOT NULL
SYS3 TT_INTEGER NOT NULL
SYS33 TT_BIGINT NOT NULL
SYS8 TT_BIGINT NOT NULL
SYS4 TT_SMALLINT NOT NULL
NUMVARY TT_SMALLINT NOT NULL
NUMNULL TT_SMALLINT NOT NULL
NUMCOLS TT_SMALLINT NOT NULL
LENGTH TT_BIGINT NOT NULL
SYS19 TT_BIGINT NOT NULL
SYS20 BINARY (1) NOT NULL
SYS21 BINARY (1) NOT NULL
SYS5 TT_SMALLINT NOT NULL
NUMLOB TT_SMALLINT NOT NULL
SYS65 TT_SMALLINT NOT NULL
SYS6 TT_BIGINT NOT NULL
SYS31 TT_BIGINT NOT NULL
SYS40 TT_BIGINT NOT NULL
SYS41 TT_BIGINT NOT NULL
SYS43 TT_BIGINT NOT NULL
SYS39 BINARY (1) NOT NULL
NUMCOMPRESS TT_SMALLINT NOT NULL
SYS64 TT_INTEGER NOT NULL
SYS7 TT_BIGINT NOT NULL
TBLID TT_BIGINT NOT NULL
NUMTUPS TT_BIGINT NOT NULL
MAXTUPS TT_BIGINT NOT NULL
SYS9 TT_INTEGER NOT NULL
SYS10 TT_INTEGER NOT NULL
SYS29 BINARY (4000) NOT NULL
SYS32 TT_BIGINT NOT NULL
SYS11 TT_BIGINT NOT NULL
PRIMCNT TT_SMALLINT NOT NULL
PRIMCOLS BINARY (32) NOT NULL
SYS22 TT_BIGINT NOT NULL
SYS12 TT_BIGINT NOT NULL
CACHEFLAG BINARY (1) NOT NULL
XLAFLAG BINARY (1) NOT NULL
PXLAFLAG BINARY (1) NOT NULL
SYS16 TT_SMALLINT NOT NULL
CACHEGROUP TT_BIGINT NOT NULL
OCACHEGROUP TT_BIGINT NOT NULL
MVID TT_BIGINT NOT NULL
MVIDS TT_VARCHAR (1024) NOT INLINE
CGFKIDS TT_VARCHAR (8192) NOT INLINE
PERMLTBLID TT_BIGINT NOT NULL
SYS44 TT_INTEGER NOT NULL
CVVERSIONNUM TT_INTEGER NOT NULL
SYS24 TT_SMALLINT NOT NULL
SYS57 TT_SMALLINT NOT NULL
SYS25 TT_INTEGER NOT NULL
REPNUMKEYCOLS TT_SMALLINT NOT NULL
REPTSCOLNUM TT_SMALLINT NOT NULL
REPRETURNSERVICE TT_CHAR (1) NOT NULL
REPRETURNBYREQUEST BINARY (1) NOT NULL
REPUSERID TT_BIGINT NOT NULL
SYS34 TT_INTEGER NOT NULL
SYS35 TT_INTEGER NOT NULL
SYS36 TT_BIGINT NOT NULL
SYS37 TT_BIGINT NOT NULL
REPKEYCOLS BINARY (32) NOT NULL
SYS27 BINARY (240) NOT NULL
REPACCESS TT_CHAR (1) NOT NULL
REPTSUPDATERULE TT_CHAR (1) NOT NULL
SYS45 TT_SMALLINT NOT NULL
SYS46 TT_BIGINT NOT NULL
SYS47 TT_INTEGER NOT NULL
SYS48 TT_INTEGER NOT NULL
SYS49 TT_INTEGER NOT NULL
SYS50 TT_INTEGER NOT NULL
SYS51 TT_INTEGER NOT NULL
SYS52 TT_INTEGER NOT NULL
SYS53 TT_INTEGER NOT NULL
SYS54 TT_INTEGER NOT NULL
SYS55 TT_BIGINT NOT NULL
SYS56 TT_BIGINT NOT NULL
SYS28 BINARY (16) NOT NULL
CACHEDTBLPOS TT_INTEGER NOT NULL
SYS58 TT_SMALLINT NOT NULL
SYS59 TT_SMALLINT NOT NULL
SYS60 TT_BIGINT NOT NULL
SYS61 TT_BIGINT NOT NULL
SYS62 TT_BIGINT NOT NULL
VALTBLIDS VARBINARY (8000) NOT INLINE
SYS63 TT_INTEGER NOT NULL
SYS66 TT_INTEGER NOT NULL
SYS67 TT_BIGINT NOT NULL
SYS68 TT_BIGINT NOT NULL
SYS17 BINARY (32) NOT NULL
1 table found.
(primary key columns are indicated with *)
I searched white book of Timesten11.2, but the columns of sys.tables in it is different from above.
also, in http://docs.oracle.com/cd/E13085_01/doc/timesten.1121/e17114/systemtables.htm#TTSYS379, I can't find it.
Thanks a lot .