建用户表空间

//建表空间
create tablespace TS_UPCFJ_USER
datafile
    'f:/oracle/tablespace/TS_UPCFJ_USER.dbf'
    size 200M
    autoextend on  next 100M maxsize UNLIMITED
     extent management
        local
             autoallocate
    segment space management auto
;

//删除用户
drop user civilinterview cascade;

//创建用户并指定表空间 
create user username identified by password 
default tablespace test_data 
temporary tablespace test_temp; 

//给用户授予权限 

grant connect,resource to username;