Fix ORA-01950: Tablespace Privileges Error

Error: While transfer the data into the table in HR schema get the following error:

ORA-01950: no privileges on tablespace "TABLESPACE_NAME"

Details:

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.

Solution: Assign space on the tablespace to a user. It is unlimited or specify the limit for the user.

Alter the quota of tablespace to user HR:

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

Example:
ALTER USER HR quota unlimited on USERS;

-- For specific size limit:
ALTER USER <username> QUOTA 1024M ON <tablespace name>;

Grant quota on all tablespace to specific user:

GRANT UNLIMITED TABLESPACE TO <username>;

Example:
Grant unlimited tablespace to HR;