ORACLE 备份表,库

备份库

exp 用户名/密码@库名 file=***.dmp log=***.log OWNER=用户名
例:exp fiauser/password@fias file=/home/oracle/fias_bak/fias.dmp OWNER=fiasuser

备份表

exp fiauser/password@fias buffer=50000000 tables=‘tablename’ file=/home/oracle/fias_bak/fias.dmp;
导入数据
imp fiauser/password@fias file=/home/oracle/fias_bak/fias.dmp tables=‘tablename’ ;