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