Tag: create table

Database, Errors and Bugs, SQL | PLSQL

ORA-01950 On Insert but not on Create Table

 , , ,

Sounds weird creating table does not raise any error, but inserting a correct tuple in this table raise a permission error, right? Just take a look:

SQL> create table matheusdba.table_test(a number) tablespace TEST_TABLESPACE;
Table created.
SQL> insert into matheusdba.table_test values (1);
insert into matheusdba.table_test values (1)
*
ERROR at line 1:
ORA-01950: no privileges on tablespace 'TEST_TABLESPACE'

More“ORA-01950 On Insert but not on Create Table”