Oracle Tablespace assign to user

• Kiran Dalvi
• 07 Jun, 2019
• 0 Comments
• 30 Secs Read

Oracle Tablespace assign to user

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.

1. Default tablespace
2. Temporary tablespace

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