Write in front:
Oracle uses the default tablespace when creating users, which is generally not recommended because the size of the default tablespace is fixed, and if all users we create use the default tablespace, it can result in insufficient tablespace space, which can cause all users that point to the user table space to not work properly. Sounds terrible one thing, so it is recommended that you standardize the use of the database, the specification of the creation of users, here I recommend you to each user to create a separate table space object.
How to create a user, the author proposes to be divided into the following three steps:
1. Create a table space
Create tablespace empit logging datafile ' d:\app\administrator\oradata\orcl\empit.dbf ' size 1024m reuse extent Management local segment space management auto;
Create a tablespace empit and specify a size of 1024M. (I am Oracle mounted on D-disk)
2. Create a user
Create user Empit identified by empi default tablespace empit temporary tablespace temp profile default;
Create a user Empit/empi and specify a tablespace.
3. Assigning Permissions
Grant CONNECT,RESOURCE,DBA to Empit;
To create the user to assign we may use the permissions (specific permissions please refer to the relevant information, here the author is not redundant).
After creating the database user we will generally import the data into the new database, we can choose to use the command to do this, the specific action is to open the cmd window, enter the following command to execute. Imp Username/[email protected]: Port/Instance name File=filepath full=y.
Such as:
Imp empit/[email protected]/orcl file = D:\empit.dmp full=y;
As the author of the mountain, if there is unclear or the wrong expression of the place also ask you to point out. Thank you, and we will update other knowledge later.
This article is from the Oracle Advanced blog, so be sure to keep this source http://shanghc.blog.51cto.com/6834610/1931135
Oracle's Advanced Learning Creation database