2 Replication Tables
TimesTen stores metadata about replication in replication tables in your database.
Your applications can read the replication tables, but it cannot update them. If your application defines a table with the same name as a replication table, then your application can read a replication table by prefixing the replication table name with TTREP
. For example, SELECT * FROM TTREP.REPTABLES
selects rows from the REPTABLES
replication table.
Information specific to replication tables:
-
Locks acquired by users on replication tables may prevent others from defining data or executing the
SQLPrepare
ODBC function or theConnection.prepareStatement
JDBC method. -
The last character in name columns is always a space. Therefore, while the column length for name columns is 31, the maximum object name length is 30.
-
TimesTen replication tables declare certain fields as data type
TT_BIGINT
. When retrieving these columns with an ODBC program, the application must bind them usingSQL_C_SBIGINT
.Note:
Some tables contain columns named
SYS
number
. Because these columns contain values used internally by TimesTen, they are not documented in this chapter. -
The
TTREP.CLIENTFAILOVER
table is reserved for internal or future use. -
By default
PUBLIC
hasSELECT
privileges on various system and replication tables andEXECUTE
privileges on various PL/SQL objects. You can see the list of objects by using this query:SELECT * FROM sys.dba_tab_privs WHERE grantee='PUBLIC';
The
ADMIN
orSELECT ANY TABLE
privilege is required to access other system and replication tables and views.