本文共 1552 字,大约阅读时间需要 5 分钟。
=========================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=bak20141217.dmp directory=expdir logfile=bak20141217.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、将FUXV520131129.dmp放入逻辑目录dpdata_shdfcm 2、CMD控制台: //impdp zcuser/123456 DIRECTORY=dpdata_shdfcm DUMPFILE=BAK20141217.DMP SCHEMAS=zcuser impdp \"tianan/123456@orcl as sysdba\" DIRECTORY=impdp_dir DUMPFILE=20150525.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;转载地址:http://xmqaf.baihongyu.com/