how to quickly insert data as select
Improving INSERT Performance with Direct-Path INSERT

Example:

alter table foo nologging;
alter session force parallel query parallel 8;
alter session force parallel dml parallel 8;
insert /*+ append */ into foo select * from bar where some_unimportant=condition;