table not show tablespace_name
Dear all,
I have problem with some tables that don't show the tablespace_name, but it show from user_segments.
Please tell me what is the problem.
SQL> col tbl format a20
SQL> col tbs format a30
SQL> select TABLE_NAME tbl,TABLESPACE_NAME tbs from USER_TABLES where table_name in ('COSTS','PRODUCTS');
TBL TBS
-------------------- ------------------------------
PRODUCTS EXAMPLE
COSTS
SQL> select distinct segment_name tbl, tablespace_name tbs from user_segments where segment_name in ('COSTS','PRODUCTS');
TBL TBS
-------------------- ------------------------------
PRODUCTS EXAMPLE
COSTS EXAMPLE
Best regards,
Kosal