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 ~ ~ ~