windows 导出 oracle,windows 环境下oracle导入导出

--创建表空间

create tablespace EBSPACE datafile 'E:\oraclespace\EBSPACE.DEF' size 500M autoextend on next 100M maxsize unlimited logging extent management local autoallocate segment space management auto;

--创建存放数据库的DMP文件的目录

create directory db_bak as 'E:\db_bak';

--创建用户并指定表空间

create user scott identified by scott default tablespace EBSPACE  temporary tablespace temp;

--给创建的目录权限赋给用户

grant read,write on directory db_bak to scott;

--用户授权:不建议附dba权限

Grant Unlimited TableSpace To scott ;

grant imp_full_database to scott;

GRANT "CONNECT" TO scott;

GRANT  create  ANY LIBRARY TO scott;

GRANT  create  ANY PROCEDURE TO scott;

GRANT  create  ANY SEQUENCE TO scott;

--导出数据库

expdp scott/scott@ORACL directory=db_bak version=11.0 dumpfile = 20181226.dmp

--导入数据库

remap_schema用户不一致时需要指定:    remap_schema=原用户名:目标用户名

remap_tablespace:表空间不一致时需要指定：remap_tablespace=原表空间:目标表空间

impdp scott/scott@ORACL directory=db_bak dumpfile = 20181226.DMP remap_schema=test:scott remap_tablespace=SPACE:EBSPACE