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