Database Administration (MOSC)

MOSC Banner

View to show how a constraint was created

edited May 9, 2013 6:20AM in Database Administration (MOSC) 15 commentsAnswered ✓
There are two ways to create a unique constraint with index:- create a UK constraint by "alter table add constraint". The DB will create a constraint and an index in one step;
- create a unique index by "create unique index" and then create a constraint by "alter table add constraint using index".

Is there a way to identify how a constraint was created looking in the Oracle dictionary?

checking i found
that we can n query dba_objects or user_object for field  created for both index and constraint and compare

Is there another way ?

Please advice

Thanks in advance

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center