How to import dmp files in Oracle: importing dmp files in oracle

How to import dmp files in Oracle: importing dmp files in oracle

The project started to get the dmp file, and the database used 10 Gb, but it was completely unsuccessful. Later, I decided to give it a try if I wanted to export the file at 11.

If your machine is a client of 11, the results do not recognize the imp command. There is no imp execution file in the bin folder under the installation directory. The manager may not be selected when installing the client.

What should I do? Copy an imp file from the bin directory of another 11 and put it in my bin. Execution or error, No message file for product = RDBMS ,......

For a message like this, I checked it online and said that copying the content of [RDBMS \ mesg] also needs to be copied. After comparing the content, I copied it all, just in case the original one is backed up.

Copy and try again. OK.

How Does oracle import dmp files?

Start> RUN> input cmd> imp PECARD_HN/PECARD_HN@127.0.0.1: 1521/orcl file = E: \ work \ dmp \ PECARD_HN.dmp full = y

In ORACLE, how does one import the DMP file to the database using PLSQL?

Tool-import table
Select oracle Import
Select the dmp Export user from the user drop-down list.
In the "Import to" drop-down box, select the user to import
Select the dmp file to be imported in "Import file"
Click Import