--新建表空间
create tablespace T_BS datafile 'E:\oracle\icdbs\T_BS_001.dbf' size 1024m autoextend off extent management local;
--索引表空间
create tablespace I_BS datafile 'E:\oracle\icdbs\I_BS_001.dbf' size 1024m autoextend off extent management local;
--扩大表空间数据文件
alter tablespace T_BS add datafile 'E:\oracle\icdbs\T_BS_002.dbf' size 1024m autoextend off ;
--新建用户
create user bs identified by bs default tablespace T_BS temporary tablespace TEMP;
--赋权
grant resource to bs;
grant CONNECT to bs;
grant create view to bs;
grant create table to bs;
grant create synonym to bs;
grant debug connect session to bs;
grant unlimited tablespace to bs;
--修改用户密码
alter user bs identified by "bs";