Export/Import

The following scenarios are designed to allow you to gain experience and comfort with the Export and Import utilities. They are presented in order of increasing complexity.

  1. Take a full export of your database.

  2. Drop a table and then import it.

  3. Drop a user and then import the user.

  4. Perform a full import of the database.

  5. Drop a table and then use the data dictionary to determine whether to import using the full or incremental export.

  6. Perform a full import of the database using the full and incremental exports.

Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.