Query dba_users table for default_tablespace and temporary_tablespace : dba_users « System Tables Views « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Tables Views
  3. dba_users

Query dba_users table for default_tablespace and temporary_tablespace

   
SQL>
SQL> select default_tablespace, temporary_tablespace
  2    from dba_users where username = 'SCOTT';

no rows selected

SQL>
SQL>
SQL> drop table foo;

Table dropped.

SQL>
SQL>








Related examples in the same category

1.Query dba_users table
2.Displaying the Account Status of All Users
3.Verifying Resource Consumer Group Membership of Users
4.Join dba_users, dba_sys_privs
5.Join dba_users, dba_tab_privs
6.Check user name and password for users