System Tables Views Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. System Tables Views
  4. 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>