Database Backup   «Prev  Next»

Lesson 2Export and Import utility overview
ObjectiveDescribe functions of Export and Import utilities

Oracle Export-Import Utility Overview

Why do the Export and Import utilities exist, and why should you bother using them?
With so many other utilities becoming available and the changes to Oracle Enterprise Manager, you would think that these utilities would slowly disappear. Perhaps in time they will, but it is much more likely that they will be fully incorporated in other products. For the time being, these utilities do exist, are free, and are part of the Oracle Oracle Certified Professional (OCP) backup and recovery exam.

Backup types

Let us review some basic information. You can perform two types of backups:
  1. logical and
  2. physical.
Logical backups copy information from your database to a file with no regard to the physical location of data. Physical backups copy information from your database to a file with physical block location information of the database stored as part of the backup file.
Export will perform a logical backup of database objects and/or data to a physical binary file in a special Oracle format. Import will then read the file created by Export and insert database objects and/or data into an Oracle database.

The following diagram explains the use of Export and Import utilities:
Export Import Mouse database operations
  1. Transportation: Easily transports objects from one database to another.
  2. Base level database definition: Create a base level definition of your database.
  3. Disk Fragmentation: Eliminate disk fragmentation.
  4. Selected File Restore: Quickly restore database components in some situations.
  5. Data Block Corruption: Detect data block corruption.

Export and Import uses

Exporting Legacy Oracle Versions

You can also use both the Export and the Import utility to provide backward support for earlier versions of Oracle. Many sites have Oracle and Oracle7 versions running concurrently, and Export/Import will allow you to move data from an Oracle database to an Oracle7 database (and even Oracle6). Keep in mind that certain database objects are not compatible with different versions of the Oracle database.
In the next lesson, you will continue learning to use Export as part of a backup and recovery strategy.