oracle创建表空间-创建用户授权-使用
创建表空间自动增长:
create tablespace 表空间名 logging datafile '/home/u01/app/oracle/oradata/orcl/数据文件名.DBF' size 1024M autoextend on next 500M maxsize 10240M
例子:
create tablespace dbtest logging datafile '/home/u01/app/oracle/oradata/orcl/dbtest.DBF' size 1024M autoextend on next 500M maxsize 10240M
创建用户默认表空间:
create user 用户名 identified by 密码 default tablespace 表空间名;
例子:
create user test01 identified by test01 default tablespace dbtest;
授权(请根据实际权限需要设置):
grant connect,resource,DBA to 用户名;
grant create session,create table,create view,create sequence,unlimited tablespace to 用户名;
例子:
grant connect,resource,DBA to test01;
grant create session,create table,create view,create sequence,unlimited tablespace to test01;