Hi,
I just want to know is there any oracle command to do something like this.
I have a table which has the person_id as primary key and its a unique constraint. There is a index on that too.
I want to run an update like this
UPDATE person_tabale t
SET t.person_id = '4'
where t.person_id = '8';
But this gives oracle error 0001 unique constraint violated. Is there anyway to overcome this issue and do a by force update?
What I can see at the moment is droping the index and update and create index is the only solution?
Is there any alternative?
Thanks in advance,
/Garuka