DBA Hub

📋Steps in this guide1/2

Oracle Tablespace assign to user

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

oracle configurationintermediate
by OracleDba
15 views
1

Overview

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. - Default tablespace - 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;
2

Section 2

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

Comments (0)

Please to add comments

No comments yet. Be the first to comment!