Oracle 导入导出(IMP/EXP)操作

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