Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

what type of tables you cannot see in USER_TABLES

883641Apr 2 2012 — edited Apr 2 2012
I'm a bit confused over the following queries
OE > SELECT segment_name , segment_type FROM user_segments WHERE segment_name = 'CATEGORIES_TAB' ;

SEGMENT_NAME SEGMENT_TYPE
--------------------------------------------------------------------------------- ------------------
CATEGORIES_TAB TABLE

OE > SELECT table_name FROM user_tables WHERE table_name = 'CATEGORIES_TAB' ;

no rows selected

OE > SELECT COUNT(*) FROM categories_tab ;

COUNT(*)
----------
22

OE > SELECT * FROM categories_tab WHERE rownum <= 1 ;

CATEGORY_NAME CATEGORY_DESCRIPTION
-------------------------------------------------- --------------------------------------------------
hardware1 monitors

>

What type of table appears in USER_SEGMENTS, behaves as a normal table, but doesn't appear in USER_TABLES

Thank you
This post has been answered by Pierre Forstmann on Apr 2 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 30 2012
Added on Apr 2 2012
6 comments
1,004 views