Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Table

 

Query Tablespace from user_tables

SQL> SQL> select default_tablespace   2  from user_users; DEFAULT_TABLESPACE ------------------------------ SYSTEM SQL> create table foo (   2  a int ); Table created. SQL> SQL> select table_name, tablespace_name   2  from user_tables   3  where table_name = 'FOO'; TABLE_NAME                     TABLESPACE_NAME ------------------------------ ------------------------------ FOO                            SYSTEM SQL> drop table foo; Table dropped. SQL> SQL> create table foo (   2  a int )   3  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> drop table foo; Table dropped.