In actual work and study, many people need to export and back up the Oracle9i database. In this article, we will introduce a method for automatic execution: Step 1: Open notepad and enter: Exp test/test @ test file = D:/backup/% Date :~ 0, 10%. dmp log = D:/backup/% Date :~ 0, 10%. Log Save as "Database Export. Bat" Sid is test, The username and password are test/test, Call the exp command to generate corresponding data files and log files in the D:/backup directory. % Date :~ Is used to export files by date. Step 2: In the task plan on the control panel, create a task plan wizard and select the file "Export Database" for the task to be executed. bat ", the task name is random, select to execute this task every week, and check the number of days of the week to be executed (for example, select Wednesday \ Friday), start time, by default, the start date starts from the current day. Enter the user name and password and click Finish to add a scheduled Oracle Database Backup Task at PM for the specified day of the week. In this way, the automatic export backup of the Oracle 9i Database can be completed. |