When your new user is created, you can get ” ORA-01950: no privileges on tablespace ” error during Insert operation.
If you got this error, it means you don’t have priviliges on that tablespace.
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.
You can give specific quota priviliges to user on tablespace as follows.
ALTER USER <username> QUOTA 1024M ON <tablespace name>;
Or you can give unlimited quota to user on related tablespace as follows.
ALTER USER <user> quota unlimited on <tablespace name>;
Or you can give unlimited quota to user on all tablespace as follows.
GRANT UNLIMITED TABLESPACE TO <username>;
Do you want to learn Oracle Database for Beginners, then read the following articles.
2,159 views last month, 1 views today