[oracle]ORA-01950: no privileges on tablespace XXX

ORA-01950: no privileges on tablespace XXX
今天在建立一個 mview 時發生以上的 ora 錯誤, 查一下原因解法如下說明.
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.
On the ITtoolbox Forum, a confrontation concerning ORA-01950 has been posted. A replier offers information, by asking the user to solve ORA-01950 by either:
* ALTER USER QUOTA 100M ON * GRANT UNLIMITED TABLESPACE TO
And to also make sure the user has been granted Connect, Resources roles incase the user was not given Create table privileges.
https://py3939.pixnet.net/blog/post/25399528