Are those missing tables - IOTs?
If so, you will not see them as table segments, they will show up as index
segments.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, February 04, 2003 10:24 AM
Hi:
Title: RE: why these tables can not be seen from user_segments?
Hi,
I found this out the hard way to: dba_tables, all_tables, and user_tables also include views. Of course, views don't have segments.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622
They don't seem to be views, they are tables
SQL select view_name from user_views where view_name like 'DR$%';
no rows selected
SQL
-Original Message-
Sent: Tuesday, February 04, 2003 11:53 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Hi,
I found this out the hard way to:
I think you will find that these tables
are index-organized-tables. The table
definition exists, but in the absence of
an overflow, there is only an index
segment.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon a new one-day tutorial:
Cost Based Optimisation
(see
Title: RE: why these tables can not be seen from user_segments?
Wrong, dba_tables, all_tables, and
user_tables do not include views.
Views listed in dba_views, ...
ex.:
SQLWKS select table_name from dba_tables where table_name like
'PRCPV%';
TABLE_NAME
--
0 rows
Guang Mei,
All the DR$ objects are interMedia Index segments - some are tables, some
are indexes, some are IOTs. Check out OTN and/or MetaLink for docs on how
each segment type contributes to the interMedia indexing process. It's
quite interesting.
Jack C. Applewhite
Database Administrator
To: Multiple recipients of list ORACLE-L
Subject: Re: why these tables can not be seen from user_segments?
I think you will find that these tables
are index-organized-tables. The table
definition exists, but in the absence of
an overflow, there is only an index
segment.
Regards
Jonathan Lewis
I don't know what naming convention Oracle
used for the intermedia IOTs - possibly they
left them to default.
Start with:
select table_name, index_name
from user_indexes
where table_name = '{one of the missing tables}'
;
You may find that there is a primary key index
with a name
1 DEFAULT
-Original Message-
From: Igor Neyman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 04, 2003 1:53 PM
To: gmei
Subject: Re: why these tables can not be seen from user_segments?
That's exactly, what I was talking about:
IOT_TYPE is IOT, which means