duplicate table with data

1-- Copy a table (datas, columns and storage parameters)
2CREATE TABLE my_new_table AS SELECT * FROM my_source_table;
3-- Use NOLOGGING, and PARALLEL if allowed for faster copy
4CREATE TABLE my_new_table
5    PARALLEL 10 NOLOGGING
6AS
7SELECT /*+ parallel(10) */ * FROM my_source_table;
8-- To create an empty table:
9CREATE TABLE my_new_table AS SELECT * FROM my_source_table
10	WHERE rownum = 0;