ALTER TABLE Storage Conversion Example | VantageCloud Lake - Example: Convert Row-Format Table to Row-Format Table - Teradata Vantage

The following statement creates the Block File System table d1.tab2_bfs:

CREATE MULTISET TABLE d1.tab2_bfs, FALLBACK,
  NO BEFORE JOURNAL,
  NO AFTER JOURNAL,
  CHECKSUM = DEFAULT,
  DEFAULT MERGEBLOCKRATIO,
  MAP = TD_MAP1,
  (
   a INTEGER,
   b INTEGER
  )
  PRIMARY INDEX (a);

The following statement converts d1.tab2_bfs to an Object File System table:

ALTER TABLE d1.tab2_bfs, STORAGE = TD_OFSSTORAGE NOT PARTITIONED;

*** Warning: 4835 One or more table options ignored. Submit a SHOW TABLE to see resulting table definition.

The following statement shows the Object File System table definition:

SHOW TABLE d1.tab2_bfs;

CREATE MULTISET TABLE d1.tab2_bfs, NO FALLBACK,
  MAP = TD_MAP1,
  STORAGE = TD_OFSSTORAGE
  (
   a INTEGER,
   b INTEGER
  )
  NO PRIMARY INDEX
  NOT PARTITIONED;