Oracle导入远程数据库数据及导入

2017.10.14 oracle

导入命令

imp username/password@oracle_sid file=C:/Users/01/Desktop/file_name.dmp log=imp_SA_TASK.log tables=SA_TASK

1.tables可以指定多个表,多个表时,用逗号隔开

2.full=y(全部导入)和指定tables导入只能选一种,否则会报异常

错误语句:
imp username/password@remote_orcl file=C:/Users/01/Desktop/file_name.dmp full=y log=imp.log tables=SA_TASK

IMP-00024: Only one mode (TABLES, FROMUSER, or FULL) can be specified

3.使用tables指定表导入的时候,必须先删除已存在的表,否则会提示

IMP-00015: following statement failed because the object already exists:

4.REMOTE_ORCL必须在tnsnames.ora中配置

直接在命令指定ip是不允许的,错误命令:
imp username/password@192.168.100.110:1521/orcl file=C:/Users/01/Desktop/file_name.dmp full=y log=imp.log tables=SA_TASK

配置文件例子:
REMOTE_ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.110)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = REMOTE_ORCL)
    )
  )

其中`REMOTE_ORCL =`前面不能有空格,前面必须空一行

更新列表：

参考文章：

相关阅读