Oracle Database Export Backup data

1. First way: Export a database using Plsql

   1. Open Plsql, find the toolbar, export the table

2. 2

   2. Go to the Export homepage, select the folder, enter the name of the export file, click Save

3. 3

   3. Click the Export button to eject the Export data overview

4. 4

   If there is no error in the middle, you can find the DMP file in the path you selected, the backup operation is completed

   END

The second way: Enter command Export (It is highly recommended to export!!!!!!! with this ）

1. 1, click the Start button, enter CMD in the run, return

2. Enter the command: EXP username/password @sid file=f:\xx.dmp owner= username, enter ( remember!!!!!!!! do not add at the end, or you will get an error! ）

3. The prompt will appear when the export is successful

4. 4. The backed up database file can be found in the selected path

   Reprint to: https://jingyan.baidu.com/article/f71d603756425a1ab741d17e.html

Oracle Database Export Backup data