Table not found in DBA_SEGMENTS
Hi,
I've a table named LOOKUPMASTER,i wants to find its size using DBA_SEGMENTS,but in dba_segments,there is no such table.
Please help to sort out this problem.
What i've to do find this table size & why it's so?
Here is what i did.
1 select * from dba_objects
2* where object_name='LOOKUPMASTER'
SQL> /
OWNER
------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE
------------------------------ ---------- -------------- ------------------
CREATED LAST_DDL_ TIMESTAMP STATUS T G S
--------- --------- ------------------- ------- - - -
SCAN
LOOKUPMASTER
76076 SYNONYM
02-OCT-05 02-OCT-05 2005-10-02:15:31:32 VALID N N N
NEXT
LOOKUPMASTER
74336 TABLE
02-OCT-05 02-OCT-05 2005-10-02:06:43:17 VALID N N N
SQL> ed
Wrote file afiedt.buf
1 select * from dba_segments
2* where segment_name='LOOKUPMASTER'
SQL> /
no rows selected
Thanks,
Malru