Example: Changing DATABLOCKSIZE - Teradata VantageCloud Lake

Lake - Working with SQL

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
jbe1714339405530.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
jbe1714339405530
On the Object File System, DATABLOCKSIZE has a default value that you cannot change.

The following ALTER TABLE request changes the maximum data block size to 1,048,064 bytes (2047 sectors) on a system with large cylinders and repacks existing data into blocks of that size:

ALTER TABLE employee, MAXIMUM DATABLOCKSIZE IMMEDIATE;