Create table as select.... with partitions
733226Nov 20 2009 — edited Nov 20 2009Hi,
i wanted to ask if it's possible to create a table as select from, specyfing also a partition schema, or if it's possible to add to this table the partitions later. This table is very very big, so i can't use the INSERT statement(it take 16 hours when create table as takes 30 minutes)
Any suggestion will be appreciated!
Thanks in advance