Check and see if your primary key constraint is enabled. If the constraint
is not enabled, the index will not exist.

-----Original Message-----
From: dlj [mailto:[Email Address Removed] Tuesday, July 31, 2001 11:31
To: LazyDBA.com Discussion
Subject: Primary key/index problem


Hello All:

I need a little help. Here is the situation I have
a primary key that does not have an associated index
it is my understanding that ALL primary key get an
index by default can anybody please explain how this
could have happened. I check my other 312 primary keys
and they all have associated indexes. I know how to
fix the problem, I just want an explantion of how this
could have happen, to prevent it from happening in the
future.

thanx

dlj

__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/

--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page