OraFAQ Forum: Server Administration » Table is not found in DBA

Home » RDBMS Server » Server Administration » Table is not found in DBA_SEGMENTS

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Table is not found in DBA_SEGMENTS [message #190407]

Wed, 30 August 2006 10:04

gajini
Messages: 262
Registered: January 2006

Senior Member

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.


[b]  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[/b]

Thanks,
Gajini

[Updated on: Wed, 30 August 2006 13:09] by Moderator

Report message to a moderator

Re: Table is not found in DBA_SEGMENTS [message #190410 is a reply to message #190407]

Wed, 30 August 2006 10:07

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

LOOKUPMASTER seems to be a SYNONYM.
Not a table.

Report message to a moderator

Re: Table is not found in DBA_SEGMENTS [message #190429 is a reply to message #190407]

Wed, 30 August 2006 12:44

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Mahesh, I thought the same thing you did. I didn't notice that second row of output above listing LOOKUPMASTER as a SYNONYM and a TABLE.

Is the table an IOT?

Report message to a moderator