Re: Q: how can i rename IOT table constraint name ?
- From: Jared Still <jkstill@xxxxxxxxx>
- To: Amihay.Gonen@xxxxxxxxxxx
- Date: Thu, 11 Nov 2010 14:30:27 -0800
On Sun, Nov 7, 2010 at 8:35 AM, Amihay Gonen <Amihay.Gonen@xxxxxxxxxxx>wrote:
> 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 ?
>
>
alter table rename constraint
here's the doc:
http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/statements_3001.htm#i2103997
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
Other related posts:
