Use a Data Pump to export remote data to a local database

The remote database user test has a t table SQLgt; showuserUSER is TESTSQLgt; select * fromtab; TNAME

The remote database user test has a t table SQLgt; show USER user is TEST SQLgt; select * from tab; TNAME

The remote database user test has a t table.

The local database user ing does not have a t table.

Now, we need to import all objects under user test to user ing.

1. Create a database link object and link it to the database server of 10.10.10.7.

2. the user test of the Remote Data 10.10.10.7 must have the exp_full_database permission.

3. Execute export on the 10.10.10.8 server.

4. Run the import command on the 10.10.10.8 server.

5. Check the user ing on 10.10.10.8.

Note: The imported users have unlimited power to use the table space: alter user ing quota unlimited on users; the system users here certainly have this power. This can be done for a small database because it depends on the network. For large databases, export data from the data source and copy the data to the target database for import.

,