问题描述：创建表时报错ORA-01950，如下所示：

环境：oracle 11.2.0.4

1、异常重现

sys@ORCL > create tablespace leo_ts datafile '/u01/app/oracle/oradata/orcl/leo_ts01.dbf' size 100m autoextend on extent management local segment space management auto;

 

Tablespace created.

 

sys@ORCL > select name from v$datafile;

 

NAME

--------------------------------------------------------------------------------

/u01/app/oracle/oradata/orcl/system01.dbf

/u01/app/oracle/oradata/orcl/sysaux01.dbf

/u01/app/oracle/oradata/orcl/undotbs01.dbf

/u01/app/oracle/oradata/orcl/users01.dbf

/u01/app/oracle/oradata/orcl/tbs_ogg01.dbf

/u01/app/oracle/oradata/orcl/leo_ts01.dbf

 

6 rows selected.

 

sys@ORCL > create user leo identified by leo default tablespace leo_ts temporary tablespace temp;

 

User created.

 

sys@ORCL > create table leo.test as select * from dba_objects;

create table leo.test as select * from dba_objects

                                       *

ERROR at line 1:

ORA-01950: no privileges on tablespace 'LEO_TS'

2、解决过程

--授予相应权限

sys@ORCL > grant connect,resource to leo;

 

Grant succeeded.

 

sys@ORCL 2022-12-15 11:00:49> alter user leo quota unlimited on leo_ts;

 

User altered.

--此后成功创建表.

sys@ORCL 2022-12-15 11:01:02> create table leo.test as select * from dba_objects;

 

Table created.