create table target_tablename tablespace 

            target_tablespace_name nologging 

            pctfree 10 pctused 60 

            storage(initial 5M next 5M minextents 1 

            maxextents unlimited pctincrease 0)

            as select * from username.source_tablename where 条件;

　　　　INSERT /*+ APPEND */ INTO target_tablename 

            SELECT * FROM username.source_tablename where 条件; 

            COMMIT;