Use a Bulk Insert
Use a bulk insert operation with a SELECT clause for high performance data insertion.
For example, the following INSERT statement selects all of the rows from the CATEGORY table and inserts them into the CATEGORY_STAGE table.
insert into category_stage (select * from category);
The following example creates CATEGORY_STAGE as a copy of CATEGORY and inserts all of the rows in CATEGORY into CATEGORY_STAGE.
create table category_stage as select * from category;