In this post I will be describe about how we can assign the oracle tablespace to user.

While creating oracle user we need to assign the tablespace to user. there are two kind of tablespace can be assign to oracle user.

Following is the way to assign oracle tablspaces.

SQL> ALTER USER username DEFAULT TABLESPACE tablespace_name;

SQL> ALTER USER username QUOTA 4M ON tablespace_name;

SQL> ALTER USER username DEFAULT TABLESPACE tablespace_name TEMPORARY TABLESPACE temp QUOTA 100M ON tablespace_name QUOTA 0 ON my_data;

SQL> ALTER USER xyz QUOTA UNLIMITED ON tablespace_name