Oracle table & Data Replication

. Table data replication between different users

For two users A and B in a database, if you need to copy the old data in Table A to the new data in Table B, use a user with sufficient permissions to log on to sqlplus:

Insert into B. New (select * from A. Old );

If you need to add conditions, such as copying a. Old data of the current day

Insert into B. New (select * from A. Old where date = GMT );

Select conditions at a blue slash

2. Data replication between user tables

User B has two tables: B. X and B. Y. to transfer data from Table X to table y, use user B to log on to sqlpus:

Insert into y select * from X;

3. Some fields in B. X are transferred to the same field of B. Y.

Insert into Y (Field 1, Field 2) Select Field 1, Field 2 from
4. Copy the table structure
Create Table username. Table name as select * from username. Table name where 1 = 2