Get default table space for current user : Table space « Table « Oracle PL / SQL






Get default table space for current user

 

SQL>
SQL> select default_tablespace from user_users;

DEFAULT_TABLESPACE
------------------------------
SYSTEM

SQL>

           
         
  








Related examples in the same category

1.Change user default table space and temporary table space
2.Moving Tables To New Tablespaces or Storage
3.heap table
4.Show_space
5.Check space with show_space for an index with compress 1
6.Check space with show_space for an index with compress 2
7.Create two indexes on one table and check the space
8.alter tablespace
9.Map user objects to tablespaces.
10.Measure the fragmentation of free space in all of the tablespaces in a database
11.The plsql user is created using the USERS and TEMP tablespace.