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 <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.
今天在建立一個 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 <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.
