| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Query problem
did you try this?
select /*FULL(a)*/a.table_name,/*FULL(a)*/a.index_name,/*FULL(b)*/b.bytes
from dba_indexes a, dba_segments b
where a.table_name=b.segment_name
and a.table_name='<table_name>'
and a.owner='<owner_name>' ;
Received on Fri Dec 08 2000 - 13:09:38 CST
 |
 |