I will explain Grant Unlimited Tablespace Privilige in Oracle in this post.
Grant Unlimited Tablespace in Oracle
If you don’t know What is the Tablespace or you want to learn more details about Tablespaces, read the following post.
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>; GRANT UNLIMITED TABLESPACE TO MEHMET;
6,318 views last month, 2 views today