Re: Question: cleaning up PK indexes

On 29 Apr 2005 14:15:02 -0700, "DW" <dwhittier_at_shaw.ca> wrote:

>What I'd like to do is something like SELECT SEGMENT_NAME FROM
>SYS.DBA_SEGMENTS WHERE SEGMENT_TYPE = 'INDEX' and SEGMENT_SCRIPT LIKE
>'%UNIQUE INDEX%'. I know that SEGMENT_SCRIPT is not part of that view,
>but this is what I want to find.

dba_indexes has an uniqueness column and dba_constraints has a constraint_type column where constraint_type ='U' refers to the unique constraint.

select * from dict shows you all dictionary views and select * from dict_columns all columns in those views.

--
Sybrand Bakker, Senior Oracle DBA