Oracle 备份与恢复

用sqlplus备份Oracle 数据库

marz posted @ Aug 13, 2010 11:36:37 PM in sql with tags oracle backup , 5793 readers

单表备份(前提库的结构是一样的) 

导出: 
开始钮->运行->输入CMD->进入DOS界面 
EXP 用户名/密码@连接字符串 GRANTS=Y TABLES=(表名) file=C:\文件名.DMP 
导入: 
开始钮->运行->输入CMD->进入DOS界面 
IMP 用户名/密码@连接字符串 IGNORE=Y TABLES=(表名) FULL=N file=C:\文件名.DMP 

全库导 
导出: 
开始钮->运行->输入CMD->进入DOS界面 
EXP 用户名/密码@连接字符串 FULL=Y file=C:\文件名.DMP 
导入: 
开始钮->运行->输入CMD->进入DOS界面 

 

Marcus Coull said:
May 02, 2019 06:42:43 PM

Coders will praise you with take these lines from here that makes their works easy and reduce working efforts also. Professional job finders like to hire careers booster  services for handling of their resume writing needs.

check here said:
Jul 31, 2020 12:28:39 PM

The information you have posted is very useful. The sites you have referred was good. Thanks for sharing...

additional resources said:
Jul 31, 2020 04:46:03 PM

It is imperative that we read blog post very carefully. I am already done it and find that this post is really amazing.

anchor said:
Aug 01, 2020 12:31:12 AM

This is my first time i visit here and I found so many interesting stuff in your blog especially it's discussion. thank you.

browse this site said:
Aug 01, 2020 07:49:22 PM

Thanks for the post and great tips..even I also think that hard work is the most important aspect of getting success..

click for more said:
Aug 02, 2020 12:37:02 AM

I recently found many useful information in your website especially this blog page. Among the lots of comments on your articles. Thanks for sharing.

click resources said:
Aug 02, 2020 03:03:41 PM

It is a great website.. The Design looks very good.. Keep working like that!.

continue reading thi said:
Aug 06, 2020 12:49:25 PM

This is very educational content and written well for a change. It's nice to see that some people still understand how to write a quality post!

use this link said:
Aug 11, 2020 12:26:06 AM

It is imperative that we read blog post very carefully. I am already done it and find that this post is really amazing.

visit our website said:
Aug 11, 2020 09:27:03 PM

Very useful post. This is my first time i visit here. I found so many interesting stuff in your blog especially its discussion. Really its great article. Keep it up.

kệ siêu thị said:
Sep 13, 2020 12:45:18 AM

Admiring the time and effort you put into your blog and detailed information you offer!..

Zscape Games said:
Sep 14, 2020 11:44:26 PM

Admiring the time and effort you put into your blog and detailed information you offer!..

more info here said:
Oct 11, 2020 05:20:24 PM

Thanks for the blog post buddy! Keep them coming...

look at here now said:
Oct 12, 2020 08:44:30 PM

I am definitely enjoying your website. You definitely have some great insight and great stories.

fk planes said:
Oct 26, 2020 11:13:58 PM

Great write-up, I am a big believer in commenting on blogs to inform the blog writers know that they’ve added something worthwhile to the world wide web!..

Paypal smm panel said:
Nov 05, 2020 06:53:08 PM

This type of message always inspiring and I prefer to read quality content, so happy to find good place to many here in the post, the writing is just great, thanks for the post.
Paypal smm panel

Carl Robert Scholz said:
Jan 27, 2021 11:48:14 PM

Your content is nothing short of brilliant in many ways. I think this is engaging and eye-opening material. Thank you so much for caring about your content and your readers.

click over here said:
Mar 25, 2021 11:08:23 PM

Very nice article, I enjoyed reading your post, very nice share, I want to twit this to my followers. Thanks!.

Geilomat said:
Mar 29, 2021 07:31:04 PM

Great write-up, I am a big believer in commenting on blogs to inform the blog writers know that they’ve added something worthwhile to the world wide web!..

buy trendy artful wo said:
Apr 08, 2021 06:25:20 AM

Great article with excellent idea!Thank you for such a valuable article. I really appreciate for this great information..

find out this here said:
Apr 11, 2021 10:57:31 PM

I really thank you for the valuable info on this great subject and look forward to more great posts. Thanks a lot for enjoying this beauty article with me. I am appreciating it very much! Looking forward to another great article. Good luck to the author! All the best!

AP 10th Physics Mode said:
Sep 15, 2022 10:49:46 PM

Physical Science is the part of Science known as Physics (PS), every student in class 10th grade studying at Government & Private Schools of the state board can download the AP SSC PS Model Paper 2023 with answers for all topics of the course designed by the board experts based on the new revised syllabus and curriculum of the BSEAP. Either Telugu medium, English medium and Urdu medium students of class 10th can download the AP SSC Physics model papers 2023 to practice with regular revisions and mock tests. AP 10th Physics Model Paper Class teachers and leading institutional experts are prepared those AP 10th Class PS Model Paper 2023 Pdf with answers that support all exam formats of the board such as Summative Assessments (SA-1 & SA-2) and Formative assessments (FA-1, FA-2, FA-3, FA-4) along with Assignments.


Login *


loading captcha image...
(type the code from the image)
or Ctrl+Enter