Table not found in DBA_SEGMENTS

[malru]

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

[jhmartin]

Is lookupmaster a global temporary table? In that case it would not have a segment unless it was currently populated.

[ebrian]

Looks like that object is a SYNONYM.

[tabreaz]

Owner
------------------------------
Object_name
--------------------------------------------------------------------------------
Subobject_name Object_id Data_object_id Object_type
------------------------------ ---------- -------------- ------------------
Created Last_ddl_ Timestamp Status T G S
--------- --------- ------------------- ------- - - -
Scan
Lookupmaster
76076 [b] synonym [/b]
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

[ebrian]

Sorry...I didn't notice that second row of output above. Is the table an IOT?

I would have thought temporary too as jhmartin mentioned, but the temporary column is set to N in the output above.

[malru]

Is there anyway to find the size of the table LOOKUPMASTER?

Thanks,
Malru

[davey23uk]

well if you cant find it

do select avg_row_len * num_rows from user_tables where table_name = 'LOOKUPMASTER'

make sure your stats are up to date

[ebrian]

Is the table an IOT?

I love how posters don't answer the questions we ask of them, yet want us to answer ALL of their questions !!!

[malru]

Hi Ebrian,

I dont know whether it's IOT or not because it's created by the user & moreover i don't know how where to find whether LOOKUPMASTER is IOT or not.

If you've any idea,please tell me & then i'll update you whether this table is IOT or not?

Thanks,
Malru

[dbasan]

Hi Ebrian,

I dont know whether it's IOT or not because it's created by the user & moreover i don't know how where to find whether LOOKUPMASTER is IOT or not.

dba_tables