这节讲日常用到的一些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
