2018-02-27 Oracle 宅必备 这节讲日常用到的一些exp/imp命令用法 ## 1. 源库导出 ### 1.1 导出全库 ``` export NLS_LANG=american_america.al32utf8 exp \"sys/ase_sys_n@mesassy as sysdba\" direct=y recordlength=65535 FULL=y file='d:\b2brda.dmp' log='d:\b2brda.log' ``` ### 1.2 导出单表或多表 ``` exp sapsr3/sapsr3 tables=RPT_COEE_REPORT file='/expbackup/RPT_COEE_REPORT.dmp' exp fwassy/fwassy tables=markout_markcodemap file='/oraassy/markout_markcodemap.dmp' log='/oraassy/markout_markcodemap.log' ``` ## 2. 目标库导入 ### 2.1 导入全库 ``` imp "'sys/ase_sys_n as sysdba'" file=/u01/b2brda.dmp log='/u01/b2brda_imp.log' fromuser=m_quiz,quiz touser=m_quiz,quiz buffer=100000000 ``` ### 2.2 导入单表 ``` imp hdbassy/hdbassy file=/oradata/RPT_COEE_REPORT.dmp log='/u01/RPT_COEE_REPORT.log' tables=RPT_COEE_REPORT ```