Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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>