Query user_tables for the table just created : USER_TABLES « System Tables Views « Oracle PL / SQL






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.

   
  








Related examples in the same category

1.query table_name, tablespace_name from user_tables
2.Query a table in user_table by table_name
3.To get a listing of all tables that you own
4.User_tables structure
5.Get table name and table space for a table by its name
6.alter table emp move tablespace users and then check the result by querying user_tables
7.Create sql statements from user_tables
8.Verify the creation of the statistics by running the following queries: