Re: Problem with dropping a Primary Key and his Index on Oracle 10R1

1. Peters wrote:

> But i drop it and dont disalbe the Primary Key. I drop it to put the
> Primary Key on a other column.

If it is possible to do this it seems highly liklely your design is flawed: Two different columns each, independently, capable of uniquely defining a unique record?

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)