RE: how can i rename IOT table constraint name ?

Just alter table ... rename constraint ...

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Amihay Gonen Sent: Sunday, November 07, 2010 6:36 PM
To: oracle-l_at_freelists.org
Subject: Q: how can i rename IOT table constraint name ?

Hi all,
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 ?

Regards,
Amihay Gonen,
System Infra Manager
amihay.gonen_at_ecitele.com<mailto:amihay.gonen_at_ecitele.com> 972-3-9268393
972-50-7058393

--
http://www.freelists.org/webpage/oracle-l