Oracle Common Operations

Source: Internet
Author: User
Tags dba

Log in Linux,sqlplus/as sysdba to log on as an administrator, normal users do not have permission to create and delete users

To create a user:

1, CREATE database table space, if the user belongs to the table space, then limit the amount of space users use

Create tablespace tablespace name datafile ' xx.dbf ' size 3000m; ------------3000m means 3000M

2, create the user, if you do not specify a tablespace, the system allocates the default tablespace, the DBA can modify the default table space

Create user username identified by password default tablespace user which tablespace to use;

3, modify the user rights, the new user does not have permissions, ordinary users under the empowerment statement is sufficient

Grant DBA, connect to user name;

To delete a user:

DROP tablespace tablespace name [including CONTENTS [and Datafiles] [CASCADE CONSTRAINTS]

Including CONTENTS: Delete all contents in table space
and datafiles: Deleting a DBF data file
CASCADE CONSTRAINTS: If a table outside the table space that you want to delete references a table in that table space , the primary key and unique key, this referential integrity constraint is removed

Oracle Common Operations

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.