Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Oracle Primary simple Logic backup and restore

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

Share

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

Oracle Primary simple Logic backup and restore

Note:

1, all commands are run at the cmd command prompt (type EXP HELP=Y or IMP HELP=Y for help).

2, the path folder must exist (in this case, the folder oracleback must exist).

Back up the fruit table under user orcl separately:

Exp userid=xxk/password direct=y tables= (fruit) file=d:\ oracleback\ baktb_fruit20140509.dmp log=d:\ oracleback\ baktb_fruit_log20140509.log

Back up all tables under user orcl:

Exp userid=xxk/password direct=y file=d:\ oracleback\ bakdb20140509.dmp log=d:\ oracleback\ baklog20140509.log

Back up all (using system users)

Exp userid=system/password direct=y full=y file=d:\ oracleback\ bakall_db20140509.dmp log=d:\ oracleback\ bakall_db_log20140509.log

Restore according to user and table

Imp userid=xxk/password file=d:\ oracleback\ baktb_fruit20140509.dmp log=d:\ oracleback\ baktb_fruit_log20140509.log

Restore all (using system users)

Imp userid=system/password full=y file=d:\ oracleback\ bakall_db20140509.dmp log=d:\ oracleback\ bakall_db_log20140509.log

The backup takes a long time, and all the information of the system is backed up, which can basically meet the demand by user or by table.

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.

Views: 0

*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.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report