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

Thread: Table not found in DBA_SEGMENTS

  1. #1
    Join Date
    Feb 2006
    Posts
    162

    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

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

  3. #3
    Join Date
    Apr 2006
    Posts
    377
    Looks like that object is a SYNONYM.

  4. #4
    Join Date
    Sep 2005
    Posts
    278
    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

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

  6. #6
    Join Date
    Feb 2006
    Posts
    162
    Is there anyway to find the size of the table LOOKUPMASTER?

    Thanks,
    Malru

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    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

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

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

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

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