oracle11g导入或导出dump文件

1  新建表空间
create tablespace MAP_DATA
logging datafile ‘D:\app\hasee\oradata\orcl\MAP2020.dbf’
size 500M autoextend on next 100M maxsize unlimited
extent management local;
--多个表空间
ALTER USER map2020 QUOTA UNLIMITED ON SOSM_WEB_DATA;
ALTER USER map2020 QUOTA UNLIMITED ON ODS2_DATA;

2 创建用户

create user map2020
identified by map2020
default tablespace MAP_DATA
temporary tablespace TEMP
profile DEFAULT;

3 为用户赋予权限

grant connect,dba,resource,unlimited tablespace to map2020;

4 创建逻辑目录

可通过navicat创建

5 为用户赋予该目录的读写权限

grant read,write on directory dump_dir to map2020;
grant read,write on directory exp_dir to map2020;

6 执行导入

运行cmd，输入下列语句即可成功导入

impdp map2020/map2020@orcl directory=dump_dir dumpfile=20210713MAP2020.dmp full=y

如果导入

impdp map2020/map2020@orcl directory=dump_dir dumpfile=ACT_GE_BYTEARRAY.dmp full=y

导出
expdp map2020/map2020@orcl directory=exp_dir dumpfile=ACT_GE_BYTEARRAY.dmp logfile=ACT_GE_BYTEARRAY.log tables=ACT_GE_BYTEARRAY