数据库导入导出操作
图形界面
--使用sqldevepler需要开启Listener服务.cmd则只需要ORCL
--大致都一样
导入
--命令行cmd
--导出:imp hr/hr@127.0.0.1/ORCL file=d:/back/bk.dmp log=d:/back/log.log tables=emp,dept fromuser = scott touser=hr commit =y ignore=y;
--(1)表达式(那个用户那张表)
imp hr/hr@127.0.0.1/ORCL file=d:/back/bk.dmp log=d:/back/log.log tables=emp,dept fromuser = scott touser=hr commit =y ignore=y;
--(2)用户方式(DBA角色)
imp system/manager@127.0.0.1/ORCL file=d:/back/bk.dmp log=d:/back/log.log fromuser = scott touser=hr commit =y ignore=y;
--(3)全库方式DBA角色(导入全库必须时sys,system)
imp system/manager@127.0.0.1/ORCL file=d:/back/bk.dmp log=d:/back/log.log commit =y ignore=y destroy =y;
导出
--命令行cmd
--导出:exp scott/tiger@127.0.0.1(本机)/ORCL file==d:/back/bk.dmp log=d:/back/log.log tables = emp,dept;
--(1)表达式(那个用户那张表)
exp scott/tiger@127.0.0.1/ORCL file=d:/back/bk.dmp log=d:/back/log.log tables=emp,dept,
--(2)用户方式(某个用户)
exp scott/tiger@127.0.0.1/ORCL file=d:/back/bk2.dmp log=d:/back/log2.log
--(3)全库方式DBA角色(导出全库必须时sys,system)
exp system/manager@127.0.0.1/ORCL file=d:/back/bk2.dmp log=d:/back/log2.log full = y;
向导模式:exp /imp/