Re: show indexes

> Hi,
>
> how can I get meta-data information in Qracle9i?
> Especialy I'm interrested in retrieving already created indices on my tables.

Andreas,

Try dbms_metadata:

  create table t__oOo__ (
    v__vxUxv_ number,
    r__riIir__ varchar2(10)
  );   

  create index i__iIi__ on t__oOo__(v__vxUxv_);   

  set long 1000   

  select dbms_metadata.get_ddl('INDEX', 'I__III__') from dual;

hth
Rene   

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch