ORA-01950: no privileges on tablespace 'SYSTEM'

ORA-01950: no privileges on tablespace "string"

 

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

• ALTER USER <username> QUOTA 100M ON <tablespace name>
   
• GRANT UNLIMITED TABLESPACE TO <username>

And to also make sure the user has been granted Connect, Resources roles incase the user was not given Create table privileges.