Bricklen <bricklen-rem_at_yahoo.comz> wrote in
news:JJUNb.19716$Eq.17003_at_clgrps12:
> Envoy wrote:
>
>> Hi,
>>
>> how can I get meta-data information in Qracle9i?
>> Especialy I'm interrested in retrieving already created indices on my
>> tables.
>>
>> Thanks a lot in advance.
>> Andreas
>
> select * from user_indexes;
I usually default to the ALL_ versions of those views. Sure I have to type
in 'and owner = ', but I usually am not on the schema that owns the tables
and I am usually working on tables that aren't in my schema.
Received on Fri Jan 16 2004 - 13:15:56 CST
