oracle导出导入

导出：

 开始->运行->输入“cmd”->输入exp user/password@IP地址:1521/数据库实例 file=文件所在目录
 exp user/password@10.9.9.12:1521/orcl file=E:\bak.dmp

  exp 'sys/orcl@127.0.0.1:1521/orcl as sysdba' file=E:\aa.dmp owner=(userName1,userName2)

导入：

 imp user/password@127.0.0.1:1521/orcl file=E:\bak.dmp full=y
imp 'sys/orcl@10.0.0.1:1521/orcl as sysdba'  file=E:\aa.dmp fromuser=(aaa,bb) touser=(aaa,bb)  ignore=y;