How to Import dmp File in Oracle 11g Using Command Prompt

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.
  • SQL
  • 1 min read

The following is the imp command example in Oracle to import dmp file (database dump).

Import dmp File in Oracle 11g Using Command Prompt

imp userid=yourid/psw123@orcl file=f:\temp\rcp.dmp fromuser=reception touser=contacts

Output

Import: Release 11.1.0.7.0 - Production on Tue Jul 10 12:09:31 2018

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export file created by EXPORT:V10.01.00 via conventional path

Warning: the objects were exported by RECEPTION, not by you

import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
. . importing table "CONTACTS" 2 rows imported
Import terminated successfully without warnings.

See also:

  1. Import CSV file in Oracle table using stored procedure
  2. Import CSV file in Oracle using Toad
  3. Import Data from Facebook to Excel 2016