oracle-数据泵备份还原

--创建表空间
create tablespace tb1 
datafile 'E:\oracle\ora\tb1.dbf' size 100M reuse 
autoextend on next 10M;


--创建test1用户
create user test1 identified by test1
default tablespace tb1
temporary tablespace temp;


--为test1用户赋权
grant connect,resource to test1;
grant create view,create table to test1;

grant dba to test1; 

--创建表
create table hsi_user(
       name varchar2(40),
       age varchar2(40),
       address varchar2(40),
       phone varchar2(40),
       bz1 varchar2(40)
);
--插入用户数据
insert into hsi_user values ('张三','22','上海崇明区','13524716855',''); 

--创建directory对象
create directory dump_test as 'E:\test';
grant read,write on directory dump_test to test1,test2;

expdp test1/test1 directory=dump_test dumpfile=test1.dmp schemas=test1

impdp test2/test2 directory=dump_test dumpfile=test1.dmp schemas=test1 remap_schema=test1:test2 remap_tablespace=tb1:tb2