Data migration case

/*

Project requirements

Source database: 192.168.56.130

Migrated object: arcer

Tablespace: Users

　　

Target Database: 192.168.52.234

Target migration object: arcer

Tablespace: action_eims_tbs

*/

 

Implementation Process

/* -- Target database */-- Create Table space create tablespace action_eims_tbs datafile '/u01/APP/Oracle/oradata/orcl/action_eims_tbs01.dbf 'size 200 mautoextend on next 200 mmaxsize 2048 m; -- create user arcer identified by arcer default tablespace action_eims_tbs; grant dBA, connect, resource to arcer; -- view the directory object set linesize 200col owner for a15col directory_name for a30col directory_path for a80select * From dba_directories; -- create directory object create directory expdp_dir as '/home/Oracle/workstation/dump_dir '; -- Grant read, write on directory expdp_dir to arcer; -- View user object information set linesize 200col segment_name for a30col rows for a30col tablespace_name for a30select segment_name, segment_type, tablespace_name from user_segments; /* -- source database */-- export data expdp arcer/arcer directory = dmp_dir dumpfile = arcer_20140910.dmp logfile = arcer_20140910.log/* -- target database */-- import data impdp arcer/arcer dumpfile = Export directory = expdp_dir remap_schema = arcer: arcer remap_tablespace = users: action_eims_tbs

 

Data migration case