Automatic Backup of oracle databases is the simplest backup method. The task of window is scheduled to be backed up once a day. Create a new. bat file on disk D and write the following command:
Automatic Backup of oracle databases is the simplest backup method. The task of window is scheduled to be backed up once a day. Create a new. bat file on disk D and write the following command:
To create a tablespace, you must first have the database orcl plsql tool to create an SQL window for execution.
Automatic oracle Database Backup
With the simplest backup method, the job in window is scheduled to be backed up once a day.
Create a new. bat file on disk D and write the following command:
Exp manager/manager126 @ jx file = d: \ database \ % date :~ 0, 10%. dmp log = d: \ database \ % date :~ 0, 10%. log
Parameter description
Exp username/password @ Database Service name file = file storage path \ current date. dmp log = log storage path \ current date. log
The bat file added to the task plan of the window system tool will be automatically backed up.
Import the oracle database using the imp command on the cmd Terminal
Import the whole database imp user name/password file = file storage path full = y
Import a table imp user name/password file = file storage path tables = table name
,