How to create database and tablespace in oracle

This article mainly shows you "how to create databases and tablespaces in oracle", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "how to create databases and tablespaces in oracle" this article.

I. the basic operation flow at the time of creation

First log in with a user with dba privileges such as sys or system

1. Create a tablespace

Example: Create tablespace ts1 datafile'/ u01 size

two。 Create a new user and establish a relationship with the tablespace

Example: Create user oadb identified by oadb_bm1233 default tablespace ts1

3. Authorize a user to manage objects and data in that user

For example: grant connect to oadb / / access to data

Grant resource to oadb / / manage resource permissions

4. Log in to Oracle with a new user

Example: sqlplus oadb/oadb_bm1233

II. Issues that need further consideration

1. To create a table space, you need to consider the future space growth.

You can add some parameters.

Create tablespace ts1 datafile'/ u01 size

Size 5000m autoextend on (next 100m) maxsize 20480m (extent management local)

2. Correspondence between users and tablespaces

One to one, one to many.

3. User authorization and security

4. User login restrictions

These are all the contents of the article "how to create databases and tablespaces in oracle". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!