falldog 发表于 2018-9-9 12:55:09

再续解密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]
查看完整版本: 再续解密Oracle备份工具-expdp/impdp