All Forums Database
abort_session 6 posts Joined 07/14
15 Jul 2014
Copy table 1:1 with compression

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

dnoeth 4628 posts Joined 11/04
15 Jul 2014

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.

Dieter

You must sign in to leave a comment.