You can use Oracle Enterprise Manager to import the contents of a database, objects, and tables.
Note: Import and Export Enterprise Manager jobs for a 10g database are implemented as data pump jobs. If the underlying data pump job is suspended, the associated Enterprise Manager job displays a status of "Failed". Use the "Monitor Data Pump Job" button on the Enterprise Manager job summary page to resume a suspended data pump job. Data pump jobs that have actually failed cannot be resumed; attempting to do so generates an informational message. If the data pump job subsequently succeeds, the Enterprise Manager job displays a status of "Successful".
To import data from a file, follow these steps:
Navigate to the Database Home page.
On the Data Movement tab, click Import from Export Files in the Move Row Data section.
The Import wizard screens appear. Work your way through the steps, entering the type of import you want to perform (entire files, manually specify what you want to import, or read import files and select what objects you want to import), the options to designate, and the full path and name for the export files.
Click the Submit Job button to schedule the import job.