Using Data Pump to export and import in Oracle 10g
Learning objective
After completing this topic, you should be able to export and import data using Oracle's Data Pump utility.
Exercise overview
In this exercise, you're required to use Oracle's Data Pump utility to export a selected schema from the database to file.
This involves the following task:
- exporting a schema
Task 1: Exporting a schema
You want to export the HR schema of the current database to a file called HREXPORT.DMP using Oracle 10g's Enterprise Manager.
| Instructions |
|---|
| 1. Select Maintenance |
| 2. Click Export to Files |
| 3. Select Schemas |
| 4. Click Continue |
| 5. Click Add |
| 6. Select HR |
| 7. Click Select |
| 8. Click Next |
| 9. Click Next |
10. Type HREXPORT.DMP in the File Name field |
| 11. Click Next |
| 12. Click Next |
| 13. Click Submit Job |
No comments:
Post a Comment