3 Replies Latest reply: Aug 27, 2012 7:18 PM by user6258915 RSS

    where can I find meaings of each column in sys.tables

    user6258915
      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 .