oracle11g-expdp-impdp步骤

=========================DMP导出======================

首先建立directory -- expdir（导入导出都要建立,对应的E:/exp文件夹如果不存在，需要手工建立）

SQL>connect zcuser/123456 as sysdba

SQL>create or replace directory expdir as 'D:/SeeyonBackup/DATA';

SQL>grant read,write on directory expdir to public;

SQL>select *From dba_directories;

CMD执行导出命令

expdp zcuser/123456@orcl schemas=zcuser dumpfile=bak1217.dmp directory=expdir logfile=bak1217.log

=========================DMP导入======================

----------【DBA用户登入 start】-------

sqlplus system/123@orcl as sysdba

创建用户：

create user tongji identified by 123456;

grant dba to tongji;

建立表空间：

create tablespace TONGJISPACE datafile 'F:\oracle\product\10.2.0\oradata\orcl\TONGJISPACE_shdfcm.dbf' size 1M

autoextend on next 5M maxsize unlimited logging extent management

local autoallocate

修改默认表空间：

alter user zcuser default tablespace SMGSPACE;

创建dpdata逻辑目录：

create directory dpdata_shdfcm as 'D:\seeyon\install\DB\oracle11gR2\dpdata_shdfcm\';

授权逻辑目录：

grant read, write on directory dpdata_shdfcm to zcuser;

----------【DBA用户登入 end】-------

导入：（在DOS下面进行，后面不要加‘;’号，不然会报“未找到方案 zcuser;”错误）

1、将FUXV51129.dmp放入逻辑目录dpdata_shdfcm

2、CMD控制台：

//impdp zcuser/123456 DIRECTORY=dpdata_shdfcm DUMPFILE=BAK1217.DMP SCHEMAS=zcuser

impdp \"tianan/123456@orcl as sysdba\" DIRECTORY=impdp_dir DUMPFILE=0525.DMP remap_tablespace=OASPACE:tiananspace remap_schema=V350SP1G:tianan

--------删除用户及表空间，然后手动去oracle目录删除相应DBF文件

drop user zcuser cascade;

drop tablespace zcspace including contents and datafiles

--------删除逻辑目录

drop directory dpdata_shdfcm;