SQL & PL/SQL

Hi Experts,

How can we check tablespace name for created table. When I tried in USER_TABLES, it is not showing the tablespace name.

Thanks!!!

SQL> CREATE TABLE EMPLOYEES_PART   
  2  (
  3   EMPLOYEE_ID   NUMBER(6,0),
  4   FIRST_NAME   VARCHAR2(20 BYTE),
  5   LAST_NAME    VARCHAR2(25 BYTE),
  6   EMAIL      VARCHAR2(25 BYTE),
  7   PHONE_NUMBER  VARCHAR2(20 BYTE),
  8   HIRE_DATE    DATE,
  9   JOB_ID     VARCHAR2(10 BYTE),
10   SALARY     NUMBER(8,2),
11   COMMISSION_PCT NUMBER(2,2),
12   MANAGER_ID   NUMBER(6,0),
13   DEPARTMENT_ID  NUMBER(4,0)
14  )
15  TABLESPACE TS1
16  PARTITION BY HASH (DEPARTMENT_ID)
17  (
18   PARTITION P1 TABLESPACE TS2,
19   PARTITION P2 TABLESPACE TS3,
20   PARTITION P3 TABLESPACE TS4
21  ) ;


SQL> SELECT TABLE_NAME, TABLESPACE_NAME FROM USER_TABLES
  2  WHERE TABLE_NAME = 'EMPLOYEES_PART' ;

TABLE_NAME                     TABLESPACE_NAME              
------------------------------ --------------------
EMPLOYEES_PART