ORA-01950: no privileges on tablespace ‘XXXX‘

ORA-01950: no privileges on tablespace ‘XXXX’

这是在初次使用oracle数据库创建表格，往表格中插入数据时常见的错误，错误原因是用户没有权限在指定的表空间分配空间。只需要将表空间的权限授予给该用户即可。 解决办法： SQL> select count() from tab_test; **COUNT() ----------** 0

SQL> insert into tab_test values(1); insert into tab_test values(1) * ERROR at line 1: ORA-01950: no privileges on tablespace ‘CHENHAO_TBS’

SQL> conn / as sysdba Connected.

SQL> alter user “CHENHAO” quota 50M on “CHENHAO_TBS”;

User altered.

conn chenhao/oracle Connected. SQL> CREATE OR REPLACE PROCEDURE sp_test 2 AS 3 BEGIN 4 FOR I IN 1 … 100000 LOOP 5 INSERT INTO tab_test VALUES (I); 6 END LOOP; 7 COMMIT; 8 END; 9 /

Procedure created.

SQL> exec sp_test;

PL/SQL procedure successfully completed.

Mac上使用docker安装oracle_11g详解

链接: https://blog.csdn.net/qq_37145397/article/details/89462153

##oracle中常见错误及安装配置