ORA-01950: no privileges on 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.

To control the amount of disk space that a user can consume in a tablespace, you can assign a quota to the user for that tablespace. A quota can be either a specific number of bytes, a percentage of the total space in the tablespace, or unlimited. To grant a quota, you can use the following syntax:

ALTER USER username QUOTA { size | UNLIMITED | DEFAULT } ON tablespace_name;

For example, to give user Alice 100 MB of space in the tablespace TBS1, you can write:

ALTER USER Alice QUOTA 100M ON TBS1;

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>;