any way to do a CTAS to create a partitioned table?
Guess2Feb 5 2008 — edited Oct 7 2008I am CTASing from a partitioned table. I want to copy the data to a new table that I am creating and I want the new table to be partitioned the same way.
create table new_table as
select *
from old_table
does not create a partitioned table.
I tried to do
create table new_table as
select *
from old_table
(partition by ....
syntax does not work.