convert row store to column store table

[Former Member]

Hi Gurus,

Is it possible to convert row store to column store table ? Please advice

Regards,

Manoj.

[rajarshi_muhuri · Accepted solution]

you can alter tables from row to column (and vice versa) very simply

suppose X is a ROW table under schema TEST

ALTER TABLE TEST.X COLUMN

changes from type ROW to COLUMN

and to revert back, its as simple as

ALTER TABLE TEST.X ROW

[former_member217391 · Accepted solution]

Thanks Muhuri, that was indeed helpful.

[Former Member]

Its possible with below SQL command to convert row table to column table.

ALTER TABLE <Schema Name>.<Table Name> COLUMN

Replace COLUMN with ROW to convert from column to row table.

[Vitaliy-R]

Have a look at table_conversion_clause of the ALTER TABLE command in SQL Ref. Guide (p. 69) -VR