说明:CTAS 于order by子句连接
create table new_customer
tablespace customer_flip
storage (initial 500M
next 50M
maxextents unlimited)
parallel(degree 11)
as select * from customer order by customer_number;
--带提示符的CTAS
create table new_customer
tablespace customer_flip
storage (initial 500M
next 50M
maxextents unlimited)
as select /*+ index(customer customer_primary_key_idx)*/ * from customer;
--nologging 方式
create table new_customer
tablespace customer_flip
storage (initial 500M
next 50M
maxextents unlimited)
unrecoverable
as select /*+ index(customer customer_primary_key_idx)*/ * from customer;