ORA-01950: no privileges on tablespace | How to Solve ORA-01950 Oracle Error during Insert

Hi,

When your new user is created, you can get ” ORA-01950: no privileges on tablespace ” error during Insert operation.

 

If you got this error, it means you don’t have priviliges on that tablespace.

 

ORA-01950: no privileges on tablespace "TABLESPACE_NAME"

Cause: User does not have privileges to allocate an extent in the specified tablespace.

Action: Grant the user the appropriate system privileges or grant the user space resource on the tablespace.

 

 

 

You can give specific quota priviliges to user on tablespace as follows.

ALTER USER <username> QUOTA 1024M ON <tablespace name>;

 

Or you can give unlimited quota to user on related tablespace as follows.

ALTER USER <user> quota unlimited on <tablespace name>;

 

Or you can give unlimited quota to user on all tablespace as follows.

GRANT UNLIMITED TABLESPACE TO <username>;

 

 

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/