ORA-01950: no privileges on tablespace 'USERS'

If you are using oracle as database for configuring wso2 carbon based product or other product, you might get the following kind of error.

ORA-01950: no privileges on tablespace 'USERS'

This is occurred because the created user doesn't specify the 'USERS' tablespace.

In oracle each database user should have a default tablespace. By default, a perticular user has no quota on any tablespace in the database. As a solution we can specify an unlimited quota or limiting the allocation space to store a particular user's objects within the specified tablespace ( in this case 'USERS' )

Solution 

Go to database ( better to use GUI tool like sqlplus or sqldeveloper) and execute following command to allow unlimited quota for a particular tablespace.

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


Ex - ALTER USER mydb quota unlimited on USERS;


or you can just limit the space to store objects by specifying a quota like below,

Ex - ALTER USER mydb quota 100M on USERS;