RelationalDBDesign 





Database Backup   «Prev  Next»
Lesson 8

Export and Import Utilities Conclusion

In this module, we briefly reviewed the Export and Import utilities with a view to a backup and recovery strategy.
These utilities have many other uses that go beyond this short discussion.
Using the Export and Import utilities should not be your sole backup and recovery strategy. These utilities may have a place in a larger backup and recovery plan.
Now that you have completed this module, you should be able to:
  1. Describe the functions of the Export and Import utilities
  2. Explain how to use Export
  3. Use EXPORT to perform a complete backup
  4. Use Export for incremental and cumulative backups
  5. Discuss the direct path method of using Export
  6. Use Import to restore database information
For further insight into the possible uses of Export and Import, read the Oracle documentation set. You will also need to review the documentation for all the possible parameter options that can be used with Export and Import.


New terms

The following terms were introduced in this module:
  1. Full mode: An export of the entire database. There are three options: complete, cumulative and incremental.
  2. Logical backup: Where you copy information from your database to a file with no regard to the physical location of data.
  3. Physical backup: Where you copy information from your database to a file with physical block location information stored in the backup file.
In the next module, you will learn about one of the main tools for backup and recovery - the Recovery Manager, also known as RMAN.

Using Oracle Import

Click the link below to check your knowledge of using the Import utility in Oracle.
Using Oracle Import

Export Import - Quiz

Before you move on to the next module, click the Quiz link below to complete a module conclusion quiz.
Export Import - Quiz