Copy table with all data, column¶ CREATE TABLE new_table AS SELECT * FROM old_table Copy table with column definetion only¶ CREATE TABLE new_table AS SELECT * FROM old_table WHERE ROWNUM = -1;