Database Administration (MOSC)

MOSC Banner

table not show tablespace_name

edited Nov 16, 2016 11:27AM in Database Administration (MOSC) 7 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center