Question on creating partition table with "create table as select"
A question, if i'd like to create a partition table with create table as select statement. how do i do that?
For example, there's a partition table TABLE_A. I am trying to create the same table structure table TABLE_B, what the syntax would be to create the TABLE_B?
Thanks