Copy table structure and data in oracle

Oracle replication table structure and data 1. copy the table structure and data: create table table_name_new as select * from table_name_old 2. copy only the table structure: create table table_name_new as select * from table_name_old where 1 = 2; or: create table table_name_new like table_name_old 3. copy table data only: if the two tables have the same structure: insert into table_name_new select * from table_name_old if the two tables have different structures: insert into table_name_new (column1, column2 ...) select column1, column2... from table_name_old