Table not found in DBA_SEGMENTS

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')