MYDBA@ORCL > desc user_lobs;
 Name                                               Null?    Type
 -------------------------------------------------- -------- ----------------------------------

 TABLE_NAME                                                  VARCHAR2(30)
 COLUMN_NAME                                                 VARCHAR2(4000)
 SEGMENT_NAME                                                VARCHAR2(30)
 TABLESPACE_NAME                                             VARCHAR2(30)
 INDEX_NAME                                                  VARCHAR2(30)
 CHUNK                                                       NUMBER
 PCTVERSION                                                  NUMBER
 RETENTION                                                   NUMBER
 FREEPOOLS                                                   NUMBER
 CACHE                                                       VARCHAR2(10)
 LOGGING                                                     VARCHAR2(7)
 IN_ROW                                                      VARCHAR2(3)
 FORMAT                                                      VARCHAR2(15)
 PARTITIONED                                                 VARCHAR2(3)

MYDBA@ORCL > create table test(a number, b clob);

Table created.

MYDBA@ORCL > select table_name, tablespace_name from user_lobs;

TABLE_NAME                     TABLESPACE_NAME
------------------------------ ------------------------------
TEST                           USERS

1 row selected.

MYDBA@ORCL > select table_name, tablespace_name from user_tables where table_name = 'TEST';

TABLE_NAME                     TABLESPACE_NAME
------------------------------ ------------------------------
TEST                           USERS

1 row selected.

MYDBA@ORCL > create table test(a number, i_am_a_clob clob);

Table created.

MYDBA@ORCL > col column_name format a30
MYDBA@ORCL >  select table_name, column_name, tablespace_name from user_lobs;

TABLE_NAME                     COLUMN_NAME                    TABLESPACE_NAME
------------------------------ ------------------------------ ----------------------
TEST                           I_AM_A_CLOB                    USERS

1 row selected.

MYDBA@ORCL > drop table test;

Table dropped.