Need more patience to answer ?'s in any FORUMS :DQuote:
Originally Posted by ebrian
:cool: :cool: :cool:
Printable View
Need more patience to answer ?'s in any FORUMS :DQuote:
Originally Posted by ebrian
: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
Not even a please in there?Quote:
Originally Posted by malru
TOO funny davey...my sentiments exactly !!!!!Quote:
Originally Posted by davey23uk
NOPE...no patience for that !!!! I'll save my gratuitous solution for another day.
Excellent, his employer will appreciate that :rolleyes:Quote:
Originally Posted by ebrian
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')