Oracle常规备份与恢复全库模式、用户模式、表模式对比

三种模式的命令语句及关键不同点（红色字体标记）如下所示：

1、全库模式导出/导入:

exp ‘user/pwd@ip/ORACLE_SID’file=’/data/backup/datafile1.dmp’ log=’/data/backup/datafile1_exp.log’ full=y statistics=none

imp ‘user/pwd@ip/ORACLE_SID’file=’/data/backup/datafile1.dmp’ log=’/data/backup/datafile1_imp.log’ full=y ignore=y

2、用户模式导出/导入:

exp ‘user/pwd@ip/ORACLE_SID’file=’/data/backup/datafile1.dmp’ log=’/data/backup/datafile1.log’ owner=USER1 statistics=none

imp ‘user/pwd@ip/ORACLE_SID’ file=’/data/backup/datafile1.dmp’log=’/data/backup/datafile1_imp.log’ fromuser=USER1 touser=newUSER ignore=y

3、表模式导出/导入:

exp ‘user/pwd@ip/ORACLE_SID’file=’/data/backup/datafile1.dmp’ log=’/data/backup/datafile1.log’ tables=(‘tablename1’,’tablename2’)

imp ‘user/pwd@ip/ORACLE_SID’ file=’/data/backup/datafile1.dmp’log=’/data/backup/datafile1_imp.log’ fromuser=USER1 touser=newUSER ignore=y tables=(‘tablename1’,’tablename2’)