Grant Unlimited Tablespace Privilige in Oracle

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.

 

What is the Tablespace in Oracle

 

 

 

 

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;

 

 

 

 

 

Do you want to learn Oracle Database Performance Tuning detailed, then Click this link.

Performance Tuning and SQL Tuning Tutorial in the Oracle Database