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
Import: Release 126.96.36.199.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 188.8.131.52.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.
- Import CSV file in Oracle table using stored procedure
- Import CSV file in Oracle using Toad
- Import Data from Facebook to Excel 2016