oracle 11g导入导入,oracle 11g 导入导出

--导入测试数据库

--connect sys/password as sysdba

---删除表空间

drop tablespace pt6 INCLUDING CONTENTS;

drop tablespace ibsc INCLUDING CONTENTS;

--当首次导入时创建表空间 (运行脚本时会提示输入 &1 输入数据文件希望存放的物理地址 例如 D:\OracleData)

create tablespace pt6 datafile 'E:\app\lostcleric\oradata\ibsc\pt6.dbf' size 100m autoextend on next 10m;

create tablespace ibsc datafile 'E:\app\lostcleric\oradata\ibsc\ibsc.dbf' size 100m autoextend on next 10m;

--删除用户

drop user pt6 CASCADE;

drop user ibsc CASCADE;

--创建用户

create user pt6 identified by cape default tablespace pt6;

create user ibsc identified by cape default tablespace ibsc;

--赋权限

grant dba to pt6;

grant dba to ibsc;

grant all on dual to pt6 with grant option;

grant all on dual to ibsc with grant option;

expdp pt6/cape@MPMIBSCESYUI dumpfile=15_IBSC20140224.EXPDB schemas=(pt6,ibsc,mpm)

impdp pt6/cape@myorcl dumpfile=MPMIBSCESYUI_20140218.EXPDB schemas=(pt6,ibsc)

expdp pt6/cape@MYORCL dumpfile=EASYUI_MYORCL_20140331.EXPDB  logfile=EASYUI_MYORCL_20140331.log schemas=(pt6,ibsc,train,mpm)

EXPDP USERID='SYS/sys@daggis as sysdba' schemas=oa directory=DATA_PUMP_DIR dumpfile=dag.dmp logfile=dag.log version=10.2.0.1.0

---将高版本的数据库转换为低版本的数据文件

EXPDP USERID='SYS/cape@myorcl as sysdba' schemas=(pt6,ibsc,mpm) directory=DATA_PUMP_DIR dumpfile=muorcl2014-03-21.dmp logfile=dag.log version=10.2.0.1.0