Oracle replication table structure and data, oracle replication Structure

Oracle replication table structure and data, oracle replication Structure

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