Oracle creates tablespaces and modifies user default tablespaces

-- Table space 
-- Unlimited tablespace size ：maxsize unlimited
create tablespace wdy_data 
logging 
datafile 'D:\oracle\app\oracle\oradata\XE\wdy_data.DBF' 
size 50m 
autoextend on 
next 50m maxsize 1024m
extent management local;

-- Create a temporary table space 
create temporary tablespace wdy_temp 
tempfile 'D:\oracle\app\oracle\oradata\XE\wdy_temp.DBF' 
size 50m 
autoextend on 
next 50m maxsize unlimited
extent management local;
   
 
--2. Build users 
create user user_wdy2 identified by user_wdy2_123456 
default tablespace wdy_data 
temporary tablespace wdy_temp;


--3. Empowerment 
grant connect,resource to user_wdy2;
grant create any sequence to user_wdy2;
grant create any table to user_wdy2;
grant delete any table to user_wdy2;
grant insert any table to user_wdy2;
grant select any table to user_wdy2;
grant unlimited tablespace to user_wdy2;
grant execute any procedure to user_wdy2;
grant update any table to user_wdy2;
grant create any view to user_wdy2;


--4. Modify user default tablespace ：
alter user user_wdy2 default tablespace wdy_data