exp导出 imp导入

导出，用户的所有对象

owner：用户    grants：n无权限，y有权限   @BXJJG:为数据库名

exp bxrlzy/bxrlzy@BXJJG owner=bxrlzy file=d:/exp/bxrlzy_n.dmp grants=n log=d:/exp/log.txt

导入

full=y 导入所有

imp bxrlzy/bxrlzy@BXJJG file=d:/bxrlzy_n.dmp full=y log=d:/imp/log.txt

数据库连接配置：

BXJJG =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.4.118.149)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )