Oracle Data Pump migrates data in different tablespaces

Data migration using Data Pumps for different tablespaces: Database A: -- 1. log on to the database as a system user, create directory (testdir), and grant read and write permissions to rc user createorreplacedirectoryrc_dicase: temp; grantread, writeondirectoryrc_dictorc; -- 2. use the expdp command to export the rc

Data migration using Data Pumps for different tablespaces: Database A: -- 1. log on to the database with the system user, create directory (testdir), and grant read and write permissions to the rc user create or replace directory rc_dic as 'e: \ temp '; grant read, write on directory rc_dic to rc; -- 2. use the expdp command to export the rc

Data pump is used for data migration between different tablespaces:
Database:
-- 1. log on to the database with the system user, create directory (testdir), and grant read and write permissions to the rc user
Create or replace directory rc_dic as 'e: \ temp ';
Grant read, write on directory rc_dic to rc;
-- 2. Use the expdp command to export rc user data
Expdp rc/aaaaaa @ orcl directory = rc_dir dumpfile = testdb. dmp schemas = rc;

Database B:
-- 1. log on to the database with the system user, create directory (testdir), and grant read and write permissions to the rc user
Create or replace directory rc_dic as '/home/temp ';
Grant read, write on directory rc_dic to rc;
-- 2 impdp rc/aaaaaa @ orcl directory = rc_dir dumpfile = testdb. dmp remap_tablespace = users: newtablespace (ing between different tablespaces)

Run the preceding statements to ensure that the directory path exists and has the read and write permissions.

Command using parameter reference: http://blog.csdn.net/wanghuaiyuanwhy/article/details/6988851

Example of http://www.cnblogs.com/lanzi/archive/2011/01/06/1927731.html