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

TTREP.REPTABLES

The REPTABLES table contains subscriber-relative information about each of the columns in each table transmitted to a subscriber. This information appears in REPTABLES in the owner (transmitter) store but not in REPTABLES in the subscriber store.

Columns

Column name Type Description
REPLICATION_NAME TT_CHAR (31) NOT NULL Name for a replication scheme.
REPLICATION_OWNER TT_CHAR (31) NOT NULL The replication scheme's owner.
ELEMENT_NAME TT_CHAR (31) NOT NULL The replication name for this element, logically different from the REF_NAME of the underlying data base object. For example, the ELEMENT_NAME for a replicated table may differ from the table name. This name must be unique in a replication scheme.
SUBSCRIBER_ID TT_BIGINT NOT NULL The TT_STORE_ID for a subscriber to this element. A subscriber may not subscribe more than once to a replication element in a replication scheme.
COLNUM TT_SMALLINT NOT NULL Ordinal number of column in table (starting at 1).
COLOPTIONS BINARY (1) NOT NULL Column specification flags:

0x01 - column is in a primary key.

0x02 - column value is varying-length (VARCHAR[2],

NVARCHAR[2], VARBINARY)

0x04 - column value can be NULL.

0x08 - column values are unique.

COLTYPE TT_INTEGER NOT NULL Data type of column

 1     TT_CHAR

 2     TT_DECIMAL

 3     TT_DECIMAL

 4     TT_INTEGER

 5     TT_SMALLINT

 6     BINARY_FLOAT

 7     BINARY_FLOAT

 8     BINARY_DOUBLE

9     TT_DATE

10     TIME

11     TT_TIMESTAMP

12     TT_VARCHAR

13     DATE

14     TIMESTAMP

15     NUMBER

16     CHAR

17     VARCHAR2

18     NCHAR

19     NVARCHAR2

- 1     LONGVARCHAR

- 2     binary

- 3     VARBINARY

- 4     LONGVARBINARY

- 5     TT_BIGINT

- 6     TT_TINYINT

- 7     BIT

- 8     WCHAR

- 9     WVARCHAR

- 10   WLONGVARCHAR

Note: If you are using TimesTen type mode, for information on COLTYPE, refer to documentation from previous releases of TimesTen. For information on TimesTen type mode, see "TimesTen type mode (backward compatibility)".

COLLEN TT_INTEGER NOT NULL Length of the column

(maximum length for varying-length

columns).

COLPRECISION TT_INTEGER NOT NULL The number of digits in a fixed-point number, or the number of digits in the mantissa of a floating point number
COLSCALE TT_INTEGER NOT NULL A non-negative number. A scale of 0 indicates an integer with no digits to the right of a decimal point. For a scale of S, the exact numeric value is the integer value of the significant digits multiplied by:

10 (exp -S).

PTNNUM TT_SMALLINT NOT NULL The table partition that contains the column.
PTNCOLOFF TT_INTEGER NOT NULL The offset of the column within the partition.
PTNNULLOFF TT_INTEGER NOT NULL The offset to the null byte within the partition.
REPKEYPOSITION TT_SMALLINT NOT NULL The ordinal position of this column in the replication key described by the REPKEYCOLS.
TS_EXCEPTION_ACTION TT_CHAR (1) NOT NULL The action to take upon detecting a conflict by a timestamp-based detector. The action is specified by the ON EXCEPTION clause in the CheckConflicts portion of a CREATE MATERIALIZED VIEW statement. They appear in this column as:

\0' - action not defined

'N' - NO ACTION

'R' - ROLLBACK WORK (default)

COLNAME TT_CHAR (31) Column name