Found it :) .
Just alter table ... rename constraint ...
From: oracle-l-bounce_at_freelists.org On Behalf Of Amihay Gonen
Sent: Sunday, November 07, 2010 6:36 PM
Subject: Q: how can i rename IOT table constraint name ?
I know how to rename the IOT table name, but I can't find a way to rename the PK name.
Since it is a big table, I don't was to do CTAS .
Any idea ?
System Infra Manager