Oracle imports DMP files via cmd and some common problems ____oracle

Source: Internet
Author: User

In the process of development and project deployment, we often encounter the need to import other people's DMP database to our own computer, then how this should be imported. Here are some simple steps:

Enter the letter first, for example, if your Oracle is mounted in D, go to D,
Then find your Oracle installation path, with the command code as follows:

Then we go into this directory and we can execute our import command.

When the table is being imported, OK is indicated.
The code is as follows:

Imp hcykt/hcykt@127.0.0.1:1521/orcl  file= ' D:\work\hcykty\zdata.dmp ' full=y

IMP database username/Database Password @ip Address: port number/ Database instance name  file= ' dmp file directory ' full=y

After the import, CMD will tell you have been imported successfully, here I will not screenshot, next I said in the introduction of the time may meet some problems ~ ~

Common Error One:
IMP-00010: Not a valid file, head validation failed
IMP-00000: Failed to terminate import successfully

What is the reason for this problem?
Oracle data high version to low version is problematic, generally by the oracle10g client to oracle11g Export data operations and then import to oracle10g, if the hands only oracle11g dmp file, how to do.
The solution is simply to change the version number on the head of the DMP file to the version you are using now.
For example the original is 11G, then his head should be: –texport:v11.01.00
I changed it to my own version number: V10.02.00

So it's OK.

Common error Two:

This error has been made clear, because your users do not have DBA authority, we only need to give the user permissions on it, the code is as follows:

--Give permission
Grant CONNECT,RESOURCE,DBA to Hcykt;
commit;

Grant connect role, resource resource role, DBA database Administrator role to  database username;

This is the successful import ~ ~ ~

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: info-contact@alibabacloud.com 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.