以sys或system用户登录command window:
create user sprita1 identified by sprita1; //创建用户
select username, DEFAULT_TABLESPACE from dba_users; //查看sprita1的默认表空间
create tablespace sprita1_oracleSpace datafile 'E:\sprita1_oracleSpace\sprOrcSpa.dbf' size 100m; //创建新的表空间
alter user sprita1 default tablespace sprita1_oracleSpace; //给用户赋予新的表空间
grant create session, create table, create view, create sequence, unlimited tablespace to sprita1; //给用户在表空间下执行操作的权限
show user; //显示当前用户
conn sprita1/sprita1; //切换到新用户
create user sprita1 identified by sprita1; //创建用户
select username, DEFAULT_TABLESPACE from dba_users; //查看sprita1的默认表空间
create tablespace sprita1_oracleSpace datafile 'E:\sprita1_oracleSpace\sprOrcSpa.dbf' size 100m; //创建新的表空间
alter user sprita1 default tablespace sprita1_oracleSpace; //给用户赋予新的表空间
grant create session, create table, create view, create sequence, unlimited tablespace to sprita1; //给用户在表空间下执行操作的权限
show user; //显示当前用户
conn sprita1/sprita1; //切换到新用户