再续解密Oracle备份工具-expdp/impdp
(1)创建表空间SQL> create tablespace lipengfei datafile '/home/oracle/app/oracle/oradata/ecom/lipengfei.dbf' size 100M AUTOEXTEND OFF;
(2)创建用户指定密码及默认表空间
SQL> create user lipengfei identified by lipengfei default tablespace lipengfei;
(3)解锁新创建的用户
SQL> alter user lipengfei account unlock;
(4)给新建的用户授权最基本的角色及权限
SQL> grant connect,resource to lipengfei;
SQL> grant create table to lipengfei;
SQL> grant create view to lipengfei;
(5)将数据泵指定的directory读写权限授权lipengfei
SQL> grant read, write on directory EXPDP to lipengfei ;
(6)登录lipengfei,创建表及数据初始化
sqlplus lipengfei/lipengfei
create table hehe(a int,b varchar2(10));
insert into hehe values(2,'d');
insert into hehe values(4,'e');
insert into hehe values(6,'f');
commit;
create view nimei as select a from hehe;
create table haha(id int);
insert into haha values(1);
commit;
(7)导出lipengfei用户所有对象
expdp lipengfei/lipengfei directory=expdp dumpfile=lipengfei_all.dmp SCHEMAS=LIPENGFEI logfile=lipengfei_all.log
(8)登录lipengfei模拟数据全部丢失
sqlplus lipengfei/lipengfei
drop view nimei;
drop table hehe;
drop table haha;
(9)把上面导出的数据还原回lipengfei用户
impdp lipengfei/lipengfei directory=expdp dumpfile=lipengfei_all.dmp logfile=lipengfei_all.log
页:
[1]