Oracle error

ORA-01950

ORA-01950: no privileges on tablespace '%s'

What usually causes it

The owner of the object has no quota on the tablespace.

What to check first

ALTER USER owner QUOTA 10G ON tablespace (or UNLIMITED). Prefer a quota to the UNLIMITED TABLESPACE system privilege.

Scripts that help

• All privileges for one userPrompts for a username and lists the roles, system privileges and object privileges granted directly to it.

Open in the error lookupOracle's reference