Reorganizing OFS Tables using OFS Scheduler | Teradata VantageCloud Lake - Reorganizing OFS Tables using OFS Scheduler - Teradata VantageCloud Lake

Lake - Manage and Move Data

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

OFS tables are being reorganized every hour (if they meet the criteria, REORG_FACTOR) using the job ReorganizeTables. However, you can customize which tables to reorganize or exclude. You can create a list using TD_OFSDB.CreateReorgList, and add tables to it using TD_OFSDB.AddReorgObjectsToList.