Home » RDBMS Server » Server Administration » Table is not found in DBA_SEGMENTS
Table is not found in DBA_SEGMENTS [message #190407] Wed, 30 August 2006 10:04 Go to next message
gajini
Messages: 259
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
LOOKUPMASTER seems to be a SYNONYM.
Not a table.
Re: Table is not found in DBA_SEGMENTS [message #190429 is a reply to message #190407] Wed, 30 August 2006 12:44 Go to previous messageGo to next message
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?
Re: Table is not found in DBA_SEGMENTS [message #190431 is a reply to message #190429] Wed, 30 August 2006 13:11 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
That was a good catch.
The table owned by NEXT has to be an IOT.
Re: Table is not found in DBA_SEGMENTS [message #190463 is a reply to message #190407] Wed, 30 August 2006 22:27 Go to previous message
gajini
Messages: 259
Registered: January 2006
Senior Member
Thanks all for your input.

May i know how to find the size of an IOT i.e, size of LOOKUPMASTER?
Previous Topic: Oracle 10G - shutting down not killing all processes
Next Topic: What is mounting really mean??
Goto Forum:
  


Current Time: Mon Dec 05 09:11:02 CST 2016

Total time taken to generate the page: 0.10595 seconds