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

There are three modes of ORACLE database backup: table backup, user backup and full backup.

There are two ways: DOS command execution: table backup:

Xporting: exp scott/tiger@orcle tables=emp,dept rows=y indexes=y commit=y file=c:/emp_exp_Date.dmp log=c:/emp_exp.log

Import: imp scott/tiger@orcle fromuser=scott touser=hu rows=y indexes=y commit=y file=c:/emp_imp_Date.dmp log=c:/emp_exp_imp.log

User backup:

Xporting: exp scott/tiger@orcle owner=scott rows=y indexes=y file=c:/emp_exp_Date.dmp log=c:/emp_exp.log

Import: imp scott/tiger@orcle fromuser=scott touser=hu rows=y indexes=y commit=y file=c:/emp_imp_Date.dmp log=c:/emp_exp_imp.log

Full backup:

Xporting: exp scott/tiger@orcle full=y rows=y indexes=y file=c:/emp_exp_Date.dmp log=c:/emp_exp.log

Import: imp scott/tiger@orcle full=y rows=y indexes=y commit=y file=c:/emp_imp_Date.dmp log=c:/emp_exp_imp.log

Back up the database through PL/SQL:

Export:

Import:

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.