 constraint and index issue [message #140336] |
Mon, 03 October 2005 17:35 |
samweber
Messages: 5
Registered: September 2005
|
Junior Member |
|
|
if I create an index indirectly through the creation of a Primary or Unique key, under what circumstances will the dropping of that constraint fail to remove the associated index?
If someone else rebuilds or recreates the index with an alter or create index sql, would that cause the above situation?
The problem is that I have an automated PL/SQL script which first removes, then re-creates a series of PK and Unique constraints. This script has been working fine against numerous client databases but... in one client, the 2nd re-create part is failing because the objects already exist.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
