MultiVersionInfoTblV[X] - Teradata VantageCloud Lake

Lake - Database Reference

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
ohi1683672393549.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
ohi1683672393549

Category: Cloud

Database: DBC

View Column Data Type Format Description
DatabaseName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Database name of the OFS table.
TableName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Name of the OFS table.
OFSStartVersionNumber BIGINT --,---,---,---,---,---,--9 Version number of the first root generated in the transaction.
OFSStartBasePUID CHAR(36) LATIN NOT CASESPECIFIC X(36) BasePUID of the first root generated in the transaction.
OFSEndVersionNumber BIGINT --,---,---,---,---,---,--9 Version number of the last root generated in the transaction.
OFSEndBasePUID CHAR(36) LATIN NOT CASESPECIFIC X(36) BasePUID of the last root generated in the transaction.
VersionTimeStamp TIMESTAMP(6) WITH TIME ZONE YYYY-MM-DDBHH:MI:SS.S(6)Z Timestamp value corresponding to the version number.
SaveCount INTEGER NOT NULL --,---,---,--9 Number of times a table is saved. Value >0 indicates a saved version and cannot be deleted. Default value is 0 and can be deleted.
ReorganizeTimeStamp TIMESTAMP(6) WITH TIME ZONE YYYY-MM-DDBHH:MI:SS.S(6)Z Timestamp of reorganize operation for REORGANIZE versions, or NULL otherwise.
BackupCount INTEGER NOT NULL --,---,---,--9 Number of times a table is archived. A value greater than 0 indicates an archived version and cannot be deleted. The default value is 0 and can be deleted.