Oracle table organization and data replication, oracle table Organization

Oracle table organization and data replication, oracle table Organization

1. Copy the table structure and data to generate a new table:

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, specify the column Name:

Insert into table_name_new (column1, column2. ..) select column1, column2.... from table_name_old

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.