用system用户登陆
-------创建表空间 需要修改 5000M 为数据库的大小根据磁盘空间而定 200M 为满空间了自动增长
create bigfile tablespace sciarr DATAFILE
'/opt/oracle/sciarr.dbf' SIZE 5000M AUTOEXTEND ON NEXT 200M
commit
------------ 创建用户
create user sciarry
identified by sciarry
default tablespace sciarr
// 授权
grant connect to 用户
grant resource to 用户
grant create sequence to 用户
grant create view to 用户
commit
-------创建表空间 需要修改 5000M 为数据库的大小根据磁盘空间而定 200M 为满空间了自动增长
create bigfile tablespace sciarr DATAFILE
'/opt/oracle/sciarr.dbf' SIZE 5000M AUTOEXTEND ON NEXT 200M
commit
------------ 创建用户
create user sciarry
identified by sciarry
default tablespace sciarr
// 授权
grant connect to 用户
grant resource to 用户
grant create sequence to 用户
grant create view to 用户
commit