How Oracle creates table spaces

How do I create a tablespace in Oracle? There are two main ways: one is to use SQL commands, and the other is created by the Oracle Client Enterprise Manager console. Here are a few separate sections:

1 Create a tablespace from SQL command

1.1 Creating a table space

Create tablespace table space name

Logging

DataFile ' D:\oracle\oradata\Oracle9i\user_data.dbf '

Size 50m

Autoextend on

Next 50m maxsize 20480m

Extent management Local;

1.2 Creating a user and specifying a tablespace

Create user username identified by password

Default Tablespace user_data

Temporary tablespace user_temp;

1.3 Authorization to the user

Grant CONNECT,RESOURCE,DBA to username;

2 Creating a tablespace from the Oracle Client Enterprise Manager Console

2.1 Open Enterprise Manager Console

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M00/82/F0/wKioL1dmXCyza3LzAAAhJCU89nA791.png-wh_500x0-wm_3 -wmp_4-s_582823027.png "title=" Qq20160619164706.png "alt=" Wkiol1dmxcyza3lzaaahjcu89na791.png-wh_50 "/>

2.2 Connecting the database

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M00/82/F1/wKiom1dmXJ-wPa7VAAEvCXJI40g646.png-wh_500x0-wm_3 -wmp_4-s_1732686412.png "title=" Eee.png "alt=" Wkiom1dmxj-wpa7vaaevcxji40g646.png-wh_50 "/>

2.3 Select a table space on the left, and create a new table space.

This article is from the "write-free" blog, please be sure to keep this source http://7156680.blog.51cto.com/7146680/1790814

How Oracle creates table spaces