oracle19c 数据泵迁移验证

一、环境准备

1.创建导出存放目录()

mkdir -p /home/oracle/data

2.创建逻辑目录（源端目标端都要）

create directory source_dbdata as '/home/oracle/data';
grant read,write on directory source_dbdata to system;

3.创建测试表空间和用户（源端目标端都要）

create tablespace test02 datafile '/u01/app/oradata/ORACLE/test02.dbf' size 10m autoextend on next 1m;
 
 
create user test02 identified by 123 default tablespace test02;
grant resource,connect,dba to test02;

4.创建测试数据

create table test02.tab1(marchantid number(10) primary key,marchantname varchar2(20) not null,email varchar2(30));
 
 
insert into test02.tab1 values(0000000001,'Java','zs@163.com');
insert into test02.tab1 values(0000000002,'Oracle','ls@163.com');
insert into test02.tab1 values(0000000003,'C++','ww@163.com');
insert into test02.tab1 values(0000000004,'Python','zl@163.com');
insert into test02.tab1 values(0000000005,'PHP','zy@163.com');
insert into test02.tab1 values(0000000006,'IOS','ht@163.com');
insert into test02.tab1 values(0000000007,'Sun','yg@163.com');

二、导出数据

1.导出数据

expdp system/123456 directory=source_dbdata dumpfile=test02.dmp tablespaces=test02 logfile=expdp.log;

2.将数据传给目标端

 scp -p /home/oracle/data/test02.dmp oracle@192.168.232.114:/home/oracle/data

三、目标端导入数据

1.导入数据

 impdp test02/123 directory=source_dbdata dumpfile=test02.dmp tablespaces=test02 logfile=impdp.log;