DD Unique Index

[Thiko]

Which Data Dictionary will tell you whether there are any unique indexes created in your database?

Created with a Create Unique index..... not an alter table add primary key statement.....

Many Thanks.

Thiko!

 

[hilbrink]

The view DBA_INDEXES contains descriptions for all indexes in the database. The field UNIQUENESS contains the status of the index: UNIQUE or NONUNIQUE

hope this was wat you meant..