Table not found in DBA_SEGMENTS - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 18 of 18

Thread: Table not found in DBA_SEGMENTS

  1. #11
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    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

    "What is past is PROLOGUE"

  2. #12
    Join Date
    Apr 2006
    Posts
    377
    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.

  3. #13
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    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?)
    "What is past is PROLOGUE"

  4. #14
    Join Date
    Feb 2006
    Posts
    162
    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

  5. #15
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Quote Originally Posted by malru
    Now,tell me how to find the size of an IOT.
    Not even a please in there?

  6. #16
    Join Date
    Apr 2006
    Posts
    377
    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.

  7. #17
    Join Date
    Jun 2006
    Posts
    259
    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

  8. #18
    Join Date
    Aug 2006
    Posts
    5
    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')

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width