Oracle import database backup DMP File

Source: Internet
Author: User
Tags import database
This command is always forgotten, so I wrote it directly on my blog for future reference. Every time I use it in the province, I will check it online.
After summing up, the following command can basically solve the problem:

/Home/Oracle/product/bin/IMP username/password full = y file = backup file path ignore = y
Replace the preceding Chinese characters with the values of your actual environment. remember that the path of the Oracle imp command is in/home/Oracle/product/bin, which is also the default installation path, if you do not know where your local Oracle installation path is, you can run the following command:

[Oracle @ ewellhopedb2 Oracle] $ CD $ ORACLE_HOME
[Oracle @ ewellhopedb2 product] $ cd./bin

Then run the IMP command in the current path. If the command is in the IMP directory, add the current path flag :. /IMP pay attention to the signature representation method... after running, it is generally OK.

One of my demos is as follows:

/Home/Oracle/product/bin/IMP zhangbo/123456 full = y file =/home/Oracle/ca_db/0523.dmp ignore = y

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.