Oracle's Advanced Learning Creation database

Source: Internet
Author: User

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

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: 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.