创建表空间和用户命令

--表空间 
CREATE TABLESPACE bieeweb DATAFILE '/opt/oracle/oradata/orcl/bieeweb' size 10G EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;  
--索引表空间 
CREATE TABLESPACE bieeweb_Index DATAFILE '/opt/oracle/oradata/orcl/bieeweb' size 512M  EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;      
 
--2.建用户 
create user bieeweb identified by bieeweb001  default tablespace bieeweb; 
  
--3.赋权 
grant connect,resource to bieeweb; 
grant create any sequence to bieeweb; 
grant create any table to bieeweb; 
grant delete any table to bieeweb; 
grant insert any table to bieeweb; 
grant select any table to bieeweb; 
grant unlimited tablespace to bieeweb; 
grant execute any procedure to bieeweb; 
grant update any table to bieeweb; 
grant create any view to bieeweb;