How to replicate table structures and table data in Oracle

1. Copy the table structure and its 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 only the table data:

If the two table structure is the same:

INSERT INTO Table_name_new select * from Table_name_old

If the structure of the two tables is different:

Insert INTO Table_name_new (Column1,column2 ...) select Column1,column2 ... from Table_name_old

How to replicate table structures and table data in Oracle