Re: index in SQL*Plus
From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Thu, 7 Nov 2002 20:02:29 -0000
Message-ID: <3dcac6d6$0$1290$cc9e4d1f_at_news.dial.pipex.com>
Date: Thu, 7 Nov 2002 20:02:29 -0000
Message-ID: <3dcac6d6$0$1290$cc9e4d1f_at_news.dial.pipex.com>
check out user_indexes and user_ind_columns.
-- Niall Litchfield [Quoted] Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ****************************************** "chess hazlett" <puneyrf_f_unmyrgg_at_enlgurba.pbz> wrote in message news:Xns92BF7C74F8F2Bpuneyrffunmyrggenlgu_at_138.126.254.210...Received on Thu Nov 07 2002 - 21:02:29 CET
> Anyone know how to find the index of a table in SQL*Plus (or, for that
> matter, PL/SQL would work, too) ?
>
> Thanks.