impdp

CREATE USER shineyue40_wh PROFILE DEFAULT IDENTIFIED BY shineyue40_wh DEFAULT TABLESPACE shineyue40_wh TEMPORARY TABLESPACE temp ACCOUNT UNLOCK;

  GRANT UNLIMITED TABLESPACE TO shineyue40_wh;     GRANT CONNECT,RESOURCE TO shineyue40_wh;     grant dba to shineyue40_wh;     CREATE OR REPLACE DIRECTORY tempdump AS ‘/home/oracle/tempdump/‘;

  GRANT READ, WRITE ON DIRECTORY tempdump TO shineyue40_wh;

   impdp shineyue40_wh/shineyue40_wh@ORCL full=Y  directory=tempdump dumpfile=aa.dmp

impdp

原文：https://www.cnblogs.com/liguofei/p/10075950.html