【Oracle impdp导入dmp文件（windows）】

本文借鉴自：https://blog.csdn.net/h18300103614/article/details/120969059

1、连接数据库

sqlplus root/123456@localhost:1521/orcl as sysdba

2、创建与导出的模式相同名称的用户WIRELESS2，并赋予权限

create user WIRELESS2 identified by WIRELESS2;

grant dba to WIRELESS2;

grant read,write on directory dmp to WIRELESS2;

3、创建directory 的物理目录f:\radio\dmp，并把.dmp文件放进去

create or replace directory dmp as ‘f:\radio\dmp’;

4、连接新用户WIRELESS2

connect WIRELESS2/WIRELESS2@localhost:1521/orcl;

5、创建表空间的物理目录F:\radio\tablespaces，并创建与导出的表空间名称相同的表空间WIRELESS

create tablespace WIRELESS datafile ‘F:\radio\tablespaces\WIRELESS.ora’ size 1m autoextend on;

6、退出数据库

exit;

7、导入数据库

impdp WIRELESS2/WIRELESS2@localhost:1521/orcl REMAP_SCHEMA = WIRELESS2:WIRELESS2 table_exists_action = replace directory=dmp dumpfile=20240315.DMP PARALLEL=6 logfile=ImpUser0120210325.log