Database Administration (MOSC)

MOSC Banner

How does Oracle know if the an index was created by the PK constraint or the index was pre-created

edited Feb 24, 2009 2:18AM in Database Administration (MOSC) 7 commentsAnswered
  If the index was created via a PK constraint Oracle knows that it is coupled and both are dropped when the
PK constraint is dropped.  If they're not coupled (index pre-created), only the constraint is dropped and the index is

left in place.
 
Which SYS view will give this information? Oracle somehow knows it.
 
In my tests the information in DBA_INDEXES and DBA_CONSTRAINTS are identical whether the index was created by the PK constraint or the index was pre-created
Thanks

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