Create / Alter Oracle TableSpace / Temporary TableSpace, User...

 

--Create TableSpace--

 

create tablespace Live_DB

logging

datafile C:/oracle/oradata/lilo/Live_DB01.dbf;

size 2m

autoextend on

next 2m maxsize 204m

extent management local;

 

 

--Create Temporary TableSpace--

 

Create Temporary tablespace Live_Temp_DB

tempfile C:/oracle/oradata/lilo/Live_Temp_DB01.dbf;

size 2m

autoextend on

next 2m maxsize 204m

extent management local;

 

 

--Create User and Assign TableSpace / Temporary Tablespace to User--

create user Lilo_X3 identified by password

default tablespace live_db

temporary tablespace live_temp_db;

 

 

--Alter User Tabblespace--

alter user lilo_x1

default tablespace live_db

temporary tablespace live_temp_db;

 

 

--Grant Permission Connect Oracle and Create Oracle Object to User--

grant connect,resource to lilo_X1;