How can I import the tables in the old database into the new database?

zmtshax

A database application is being designed. In the middle of the design, the database was re-planned, so the original database is no longer used, and a new database and database table structure are enabled. However, an important table has been output in the original. A lot of data, after checking the structure of the new database table and the original database table, and found that the structure of the table has not changed, in order to use the original data in the new database, how to do the best?

海蓝之谜

Method 1. Export this table in the original database, and then import it into the new database. Use EXP and IMP.
2.Start both databases, use DBLINK, create an identical table in the new database, and then directly use SQL statements to insert data from the old database into this table in the new database

whbilly

Method 1: Use exp / imp to export and import according to the table
Option 2: Use the copy command
Method 3: Use db_link for insert

wepengskywz

On the same machine, use insert into new_table select * from old_tab where 1=1; This is ok

a476956723

exp table.
If both libraries coexist, then directly, create table xx as select * from xxx;