SYSBACKUPITEMS System Table

The SYSBACKUPITEMS table maintains information about each item (table) backed up during a backup.

SYSBACKUPITEMS system table
Column Name Type Length Nullable Contents
BACKUP_ID BIGINT 19 NO The backup ID.
ITEM VARCHAR 32642 NO The name of the item.
BEGIN_TIMESTAMP TIMESTAMP 29 NO The start time of backing up this item.
END_TIMESTAMP TIMESTAMP 29 YES The end time of backing up this item.
SNAPSHOT_NAME VARCHAR 32642 NO The name of the snapshot associated with this item.