Synchronize the tables in the official database with the test library __ Database

Just contact the project intern, accumulate experience, welcome to Exchange

Today, we have a problem of synchronizing the formal library data with the test library

Directly to the solution:

Method One:
Generate DMP files using the EXP command line on the official library server, import the test library with imp command

Method Two:

Test the database on the Dblink connection on the formal library, then test the library, truncate the table, and then execute it in the official library:

INSERT INTO Test library table name @dblink name SELECT * From official library table name