Shulou(Shulou.com)06/01 Report--

Oracle command line login

Sqlplus username / password

Create a user

Create user user identified by password

Create a tablespace

Create tablespace tablespace name datafile'D:\ oracle11\ oradata\ library name\ XXX.pdf' size 200m autoextend on next 50m maxsize 1000m

User authorization

Grant connect, resource to user name

Log in to the oracle database with the user name and password you created

Conn username / password

The most authorized authority

Log in with the highest privilege account

Grant dba to user name

Imp Import dmp

This command needs to be executed directly in the dos command window of cmd, instead of sqlplus.exefull=y importing all the contents of the file ignore=y is equivalent to, if there is no table, create and pour the data, if there is already a table, ignore the created, but do not ignore the reverse

Imp user / password file= file path full=y ignore=y

Summary

The above is introduced by the editor to you the method of importing dmp files into oracle with imp. I hope it will be helpful to you. If you have any questions, please leave a message for me, and the editor will reply to you in time. Thank you very much for your support to the website!

If you think this article is helpful to you, you are welcome to reprint it, please indicate the source, thank you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.