ORA-01950: no privileges on tablespace ‘USERS’

In this blog let us we will see how to solve ORA-01950.

This error occurs if a user doesn’t have the quota to the right tablespace, in my case my user doesn’t have the access to “USERS” Tablespace.

To fix this issue we can grant the unlimited quote to the user or grant-specific size of the tablespace that can be utilized by the schema. It’s good to always create specific tablespaces and associate it with any new schema created on the database, we might think why there are many scenarios where maintenance.

I am going to give unlimted quote as this is sample database, but in real world better to allocate speifci size required :

ALTER USER <user> QUOTA UNLIMITED on <tablespace name>;

OR use like below

ALTER USER <user> QUOTA 300M on <tablespace name>;

After granting let us try the insert.

Thank you for reading my blog, please feel free to leave me some feedback or to suggest any future topics.

Looking forward to hearing from you – Swadhin Ray (Sloba) -( LinkedIn ) ( Twitter )

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.