Oracle create user, table space

1. First, create a (new) User:
Create user username identified by password;
Username: User name for new username
Password: New user's password
You can also not create a new user, but still use the previous user, such as: Continue to use the Scott user

2. Create TABLE spaces:
Create tablespace tablespacename datafile ' d:\data.dbf ' size xxxm;
Tablespacename: Name of table space
D:\DATA.DBF ': Table Space Storage location
The size of the XXX table space, m units in megabytes (m)

3. Assign space to the user:
Alert user username default tablespace tablespacename;
Assign a tablespace named Tablespacename to username

4. Authorization to the User:
Grant Create Session,create table,unlimited tablespace to username;

5. Then log in with the user you created, and create a table after logging in.
Conn Username/password;

/*

Create tablespace onlinevisasystem_tablesapce logging datafile ' D:\OnlineVisaSystem.dbf ' size 10000m autoextend on next 1 00m maxsize 20048m extent management local;

Create user Onlinevisasystem identified by DWJD2014 default tablespace onlinevisasystem_tablesapce temporary tablespace t Emp

Grant Connect, resource, dba to Onlinevisasystem;

Commit
*/

Oracle create user, table space