Copy table 1:1 with compression

Database
Enthusiast

Copy table 1:1 with compression

Hello,

how can i copy a table 1:1 with compression !! in one step ?

1 REPLY
Junior Contributor

Re: Copy table 1:1 with compression

What kind of compression, multi value or block level?

Based on your other question I assume MVC. You can use

CREATE TABLE new_table
(col not null compress (1,2),
...) AS existing_table WITH DATA

In fact you can specify every column attribute, just not the datatype.