-
Here is how to rename columns and constraints in 9.2.0, something what was not possible in 9.0.1:
Code:
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]
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
is it availale in release 1 ?
Santosh Jadhav
8i OCP DBA
-
Originally posted by sjadhavdba
is it availale in release 1 ?
No.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|