23 Original Import

The original Import utility (imp) imports dump files that were created using the original Export utility.

See the following topics:

• What Is the Import Utility?

• Before Using Import

• Importing into Existing Tables

• Effect of Schema and Database Triggers on Import Operations

• Invoking Import

• Import Modes

• Import Parameters

• Example Import Sessions

• Exit Codes for Inspection and Display

• Error Handling During an Import

• Table-Level and Partition-Level Import

• Controlling Index Creation and Maintenance

• Network Considerations

• Character Set and Globalization Support Considerations

• Using Instance Affinity

• Considerations When Importing Database Objects

• Support for Fine-Grained Access Control

• Snapshots and Snapshot Logs

• Transportable Tablespaces

• Storage Parameters

• Read-Only Tablespaces

• Dropping a Tablespace

• Reorganizing Tablespaces

• Importing Statistics

• Using Export and Import to Partition a Database Migration

• Tuning Considerations for Import Operations

• Using Different Releases of Export and Import