Reference Guide > TDV and Business Directory System Tables > TEMPTABLE_LOG
 
TEMPTABLE_LOG
The TEMPTABLE_LOG provides a read-only view of all active temporary tables on a specific TDV server node. TDV uses this information during a server restart to clean up any temporary tables left behind when a server is shut down or killed during a transaction.
Users need ACCESS_TOOLS and READ_ALL_STATUS rights to see the table rows.
Column
TDV JDBC Data Type
Nullable
Description
SESSION_ID
BIGINT
 
The session’s identification number.
TABLE_PATH
VARCHAR(255)
 
Full path of the temporary table.
CREATION _TIMESTAMP
TIMESTAMP
 
The time that the table was created.
TARGET_DATASOURCE_PATH
VARCHAR(2147483647)
 
The data source where the temp table data is stored.
TARGET _TABLE_PATH
VARCHAR(2147483647)
 
The physical location of the temporary table.