Import Data

Step-by-Step Guide for Importing Dump File

  1. Step 1: Ensure the Dump File is Accessible

    • Path of the Dump File on the Server: /home/username/backups/dumpfile.dmp
    • Dump File Created Using: EXPDP/EXP
    • Source Tablespace Name: USERS
    • Source Schema Name: HR
    • Destination Schema Name: HR_IMPORT

    Step 2: Determine the Import Command

    If the Dump File was Created Using EXP:

    Use the IMP command:

 imp username/password@database file=/home/username/backups/dumpfile.dmp fromuser=HR touser=HR_IMPORT

       If the Dump File was Created Using EXPDP:

       Use the IMPDP command:

impdp username/password@database directory=DATA_PUMP_DIR dumpfile=dumpfile.dmp schemas=test(replace test with schema name)

Step 3: Import the Dump File

For EXP Created Dump File:

  1. Ensure the Dump File is Accessible: Verify that the dump file (dumpfile.dmp) is accessible from the location specified.

  2. Run the IMP Command: Execute the IMP command in the Oracle environment.

For EXPDP Created Dump File:

  1. Move the Dump File to the Correct Directory: Ensure the dump file (dumpfile.dmp) is located in the DATA_PUMP_DIR directory. You might need to move the file to this directory if it's not already there.

  2. Run the IMPDP Command: Execute the IMPDP command in the Oracle environment.

        imp username/password@database file=/home/username/backups/dumpfile.dmp fromuser=HR touser=HR_IMPORT

  1. Example Command Breakdown

    IMP Command:

    • imp: The Import utility.
    • username/password@database: Your Oracle database credentials.
    • file=/home/username/backups/dumpfile.dmp: The path to the dump file.
    • fromuser=HR: The source schema.
    • touser=HR_IMPORT: The destination schema.

    IMPDP Command:

    • impdp: The Data Pump Import utility.
    • username/password@database: Your Oracle database credentials.
    • directory=DATA_PUMP_DIR: The directory object where the dump file is located.
    • dumpfile=dumpfile.dmp: The name of the dump file.
    • remap_schema=HR:HR_IMPORT: Maps the source schema HR to the destination schema HR_IMPORT.

    Additional Considerations

    • Check Directory Object: Ensure that the DATA_PUMP_DIR is correctly defined and accessible. You can check this in Oracle by querying: 

                SELECT directory_name, directory_path FROM dba_directories WHERE directory_name = 'DATA_PUMP_DIR'; 

  • Verify Permissions: Ensure the user has appropriate permissions to perform the import.

By following these steps, you can successfully import the dump file into the destination schema, ensuring a smooth data migration process.


  • 3 Users Found This Useful
Was this answer helpful?

Related Articles

Connect to Database with Toad/SQL Developer etc

The Welcome Email you receive when you place an order contains Host name, port, database name,...

Access Procedure from URL

To access your procedure from the URL, make sure you grant EXECUTE privileges to APEX_PUBLIC_USER...

Data Export / Backup

You can export your data with the EXP utility provided by Oracle. The command should be like the...

Scheduled Jobs

With our shared hosting plans you are allowed to run a scheduled job maximum 4 times a day and...

Get Client IP Address

To get the IP address of your client accessing the Apex application through the browser you can...