Press "Enter" to skip to content

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

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/[email protected] 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