Oracle Data tutorial for Data Pump migration and oracle tutorial for Pump migration

Oracle Data tutorial for Data Pump migration and oracle tutorial for Pump migration

Export:

1. Create the db link of the original database first.

Create public database link db_local connect to userxx identified by passwd using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.x.x) (PORT = PORT ))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = Instance name )))';

Verify: select * from user name. Table Name @ db link name;

2. Run create directory testdb (custom DIRECTORY name, which requires manual Folder creation on the hard disk) AS 'd:/oracleData by a local user with DBA permission in the local database ';

GRANT read, write on directory testdb (custom directory name) to test;

GRANT exp_full_database, imp_full_database to local user name;

3. Execute the command expdp userid = Local User Name/password @ Instance name directory = testdb (custom directory name) dumpfile = xxxx20180222.dmp SCHEMAS = name to be exported network_link = db_local (db link name)

After completion, dmp and the exported log export. log are in the local Directory D:/oracleData.

4. Import, portal:

Study-influence relationship between IMPDP [TRANSFORM = segment_attributes: n] [remap_tablespace] 2

If you want to import exported dmp to the local machine: impdp scott/miao @ orclmxd directory = testdb dumpfile = xxxx20180222.DMP remap_schema = username (original user): scott (target user) REMAP_TABLESPACE = tb (original tablespace): (target tablespace)