oracle 11g 导入导出

来源：互联网发布：软件开发项目管理流程编辑：程序博客网时间：2024/05/16 02:33

--导入测试数据库
--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

0 0