创建表时报错ORA-01950
2025-05-13 09:51:29 阅读次数:1
ORA,创建
问题描述:创建表时报错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.
版权声明:本文内容来自第三方投稿或授权转载,原文地址:https://blog.51cto.com/u_12991611/5946568,作者:Liujun_Deng,版权归原作者所有。本网站转在其作品的目的在于传递更多信息,不拥有版权,亦不承担相应法律责任。如因作品内容、版权等问题需要同本网站联系,请发邮件至ctyunbbs@chinatelecom.cn沟通。
上一篇:rac环境节点1修改参数后,节点2启动出现ORA-01105、ORA-01677告警
下一篇:旁注,暴力pojie