How to rename columns and constraints in 9.2

[julian]

Here is how to rename columns and constraints in 9.2.0, something what was not possible in 9.0.1:

SQL> create table test(a1 sys.xmltype, a2 timestamp);

Table created.

SQL>  alter table test add constraint con_a2 primary key(a2);

Table altered.

SQL> alter table test rename constraint con_a2 to pk_a2;

Table altered.

SQL> set lines 64
SQL> desc test
 Name                            Null?    Type
 ------------------------------- -------- ----------------------
 A1                                       SYS.XMLTYPE
 A2                              NOT NULL TIMESTAMP(6)

SQL> alter table test rename column a1 to a1_xml;

Table altered.

SQL> desc test
 Name                            Null?    Type
 ------------------------------- -------- ----------------------
 A1_XML                                   SYS.XMLTYPE
 A2                              NOT NULL TIMESTAMP(6)

SQL>

Just noticed Tim's paper related to this topic:

http://www.oracle-base.com/Articles/...straints9i.asp


[Edited by julian on 05-22-2002 at 03:38 AM]

[sjadhavdba]

is it availale in release 1 ?

[julian]

Originally posted by sjadhavdba
is it availale in release 1 ?

No.

[TimHall]

No. It's a new feature of Release 2.

Remember, changing a constraint name does not rename the supporting index. For consistency you should rename both.

Cheers