数据导入导出:命令行cmd
1 导出:exp
注意:直接在cmd中执行;
a 导出表
exp scott/RJZXjl532991661@127.0.0.1/ORCL file=d:/back/bk.dmp log=d:/back/log.log tables = emp,dept;
b 导出用户里面所有表
exp scott/RJZXjl532991661@127.0.0.1/ORCL file=d:/back/bk.dmp log=d:/back/log1.log
c 全库导出(必须是dba角色 sys/system)
exp system/RJZXjl532991661@127.0.0.1/ORCL file=d:/back/bk.dmp log=d:/back/log2.log full=y;
2 导入:imp
a 表方式
imp scott/RJZXjl532991661@127.0.0.1/ORCL file=d:/back/bk.dmp log=d:/back/log.log tables=emp,dept fromuser=scott touser=qjl
b 用户方式
imp scott/RJZXjl532991661@127.0.0.1/ORCL file=d:/back/bk.dmp log=d:/back/log.log fromuser=scott touser=qjl commit=y ignore=y
c 全库方式
imp scott/RJZXjl532991661@127.0.0.1/ORCL file=d:/back/bk.dmp log=d:/back/log.log fromuser=scott touser=qjl commit=y ignore=y destroy=y