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

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

Looks like that object is a SYNONYM.

HTML Code:

---


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

---

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.

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

Thanks,
Malru

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

Quote:

---

Originally Posted by 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 !!!

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

Quote:

---

Originally Posted by 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.

---

dba_tables

Quote:

---

Originally Posted by ebrian

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

---

Need more patience to answer ?'s in any FORUMS :D

:cool: :cool: :cool:

Really don't know what not answering a question has to do with patience. I would think taking the time to respond to posters in forums is a sign of patience in and of itself.

I know posters doing all sort of R&D and coming back with answers after a month, even after a year(Davey am i right?) :)

Hi,

Yes the table is IOT.

SQL> select * from dba_tables where owner='NEXT' and table_name='LOOKUPMASTER';

OWNER TABLE_NAME
------------------------------ ------------------------------
TABLESPACE_NAME CLUSTER_NAME
------------------------------ ------------------------------
IOT_NAME PCT_FREE PCT_USED INI_TRANS MAX_TRANS
------------------------------ ---------- -------- ---------- ----------
INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE FREELISTS
-------------- ----------- ----------- ----------- ------------ ----------
FREELIST_GROUPS LOG B NUM_ROWS BLOCKS EMPTY_BLOCKS AVG_SPACE CHAIN_CNT
--------------- --- - ---------- ---------- ------------ ---------- ----------
AVG_ROW_LEN AVG_SPACE_FREELIST_BLOCKS NUM_FREELIST_BLOCKS DEGREE INSTANCES
----------- ------------------------- ------------------- ---------- ----------
CACHE TABLE_LO SAMPLE_SIZE LAST_ANAL PAR IOT_TYPE T S NES BUFFER_ ROW_MOVE
----- -------- ----------- --------- --- ------------ - - --- ------- --------
GLO USE DURATION SKIP_COR MON CLUSTER_OWNER DEPENDEN
--- --- --------------- -------- --- ------------------------------ --------
COMPRESS
--------
NEXT LOOKUPMASTER

0 0 0 0

N 2633 0 0
33 0 1 1
N ENABLED 2633 30-JUL-06 NO IOT N N NO DISABLED
YES NO DISABLED NO DISABLED
DISABLED

Now,tell me how to find the size of an IOT.

Thanks,
Malru

Quote:

---

Originally Posted by malru

Now,tell me how to find the size of an IOT.

---

Not even a please in there?

Quote:

---

Originally Posted by davey23uk

Not even a please in there?

---

TOO funny davey...my sentiments exactly !!!!!

NOPE...no patience for that !!!! I'll save my gratuitous solution for another day.

Quote:

---

Originally Posted by ebrian

TOO funny davey...my sentiments exactly !!!!!

NOPE...no patience for that !!!! I'll save my gratuitous solution for another day.

---

Excellent, his employer will appreciate that :rolleyes:

select segment_name ,bytes from dba_segments where segment_name in (select object_name from dba_objects where object_id = (select object_id +1 from user_objects where object_name='LOOKUPMASTER') and owner='NEXT')