Get table name and table space for a table by its name

 
SQL>
SQL> create table foo (a int );

Table created.

SQL>
SQL>
SQL> select table_name, tablespace_name
  2  from user_tables
  3  where table_name = 'FOO';

TABLE_NAME                     TABLESPACE_NAME
------------------------------ ------------------------------
FOO                            SYSTEM

SQL>
SQL> drop table foo;

Table dropped.

SQL>
SQL> create table foo (a int ) 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> drop table foo;

Table dropped.

SQL>
SQL>

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.	Query user_tables for the table just created
4.	To get a listing of all tables that you own
5.	User_tables structure
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:

Get table name and table space for a table by its name : USER_TABLES « System Tables Views « Oracle PL / SQL

Related examples in the same category