Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Query user_tables for the table just created

SQL> SQL> create table foo (a int)   2  tablespace users; Table created. SQL> SQL> select table_name, tablespace_name   2    from user_tables   3   where table_name = 'FOO'; TABLE_NAME                     TABLESPACE_NAME ------------------------------ ------------------------------ FOO                            USERS SQL> SQL> select username, default_tablespace, temporary_tablespace   2    from dba_users   3   where default_tablespace = 'SYSTEM' or temporary_tablespace = 'SYSTEM'; USERNAME                       DEFAULT_TABLESPACE             TEMPORARY_TABLESPACE ------------------------------ ------------------------------ ------------------------------ SYSTEM                         SYSTEM                         TEMP SYS                            SYSTEM                         TEMP DIP                            SYSTEM                         TEMP OUTLN                          SYSTEM                         TEMP MDSYS                          SYSTEM                         TEMP TSMSYS                         SYSTEM                         TEMP 6 rows selected.