Home > Article > Database > oracle中数据库的导入导出命令

oracle中数据库的导入导出命令

WBOYOriginal: 2016-06-07 17:46:081234browse

文章介绍了关于oracel导入导出,方法相当的简单有需要了解的同学可参考一下。

代码如下

复制代码

ORACLE_192.168.28.1 =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.28.1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = oracle11)
    )
)

ORACLE_192.168.28.2 =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.28.2)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = oracle22)
    )
)

1.导入,导出命令

2.数据库表中Clob,Blob 导入导出命令

exp 数据库用户名/密码@配置名称 file=输出文件路径 log=日志文件路径 tables=(数据库表名) query="查询条件"

imp 数据库用户名/密码@配置名称 file=输入文件路径 log=日志文件路径 tables=(数据库表名) ignore=y

代码如下

复制代码

exp test/test@ORACLE_192.168.28.1 file=c:11.dmp log=c:11.log tables=(table1) query="where createdby='sysadmin' and to_char(createtime,'YYYY-MM-DD')='2012-05-17'"

imp dev/dev@ORACLE_192.168.28.2 file=c:11.dmp log=c:121.log tables=(table1) ignore=y

用cmd.exe 执行就可以,注意的地方就是query 地方 "

先执行exp 后执行imp

Statement：

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Previous article：Oracle LOWER() 和 UPPER()函数的使用方法Next article：oracle中嵌套循环跳出内部循环体实例

See more

oracle中数据库的导入导出命令

Related articles