Comparison of Oracle regular backup and recovery full database mode, user mode and table mode 03/01 Update SLTechnology News&Howtos

Comparison of Oracle regular backup and recovery full database mode, user mode and table mode

2025-03-01 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Shulou(Shulou.com)06/01 Report--

The command statements in the three modes and the key differences (red font marks) are as follows:

1. Full library mode export / import:

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. User mode export / import:

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. Table schema export / import:

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')

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.