How to write the statement of creating table space in oracle

This article is to share with you about how to write the statement of creating table space in oracle. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

Before you create a user, create a tablespace:

Format:

Create tablespace inter-table name datafile 'data file name' size tablespace size

Such as:

SQL > create tablespace news_tablespace datafile'F:\ oracle\ product\ 10.1.0\ oradata\ news\ news_data.dbf' size 500m

Where 'news_tablespace' is your custom tablespace name, which can be named at will.

'F:\ oracle\ product\ 10.1.0\ oradata\ news\ news_data.dbf' is the location where the data files are stored.

'The news_data.dbf' file name is also arbitrary.

'size 500m' specifies the size of the data file, that is, the size of the tablespace. .

Now that you have built a tablespace called 'news_tablespace', you can create users.

Format:

Create user username identified by password default tablespace table space table

Such as:

SQL > create user news identified by news default tablespace news_tablespace

The default tablespace 'default tablespace' uses the tablespace created above.

Then authorize the newly created user:

SQL > grant connect,resource to news;-means to grant connect,resource permissions to news users SQL > grant dba to news;-means to grant dba permissions to news users. Thank you for your reading! About oracle create table space statement how to share here, I hope the above content can be of some help to you, so that you can learn more knowledge. If you think the article is good, you can share it and let more people see it.