RE: RENAME COLUMN IN 9I

It is a 9i Release 2 feature..
It was an enhancement request in 9i Release 1 but actually got implemented in 9i Release 2.

• Kirti

-----Original Message-----
Sent: Friday, May 16, 2003 1:27 PM
To: Multiple recipients of list ORACLE-L

That would work in 9i Release 2.

• Kirti

-----Original Message-----
Sent: Friday, May 16, 2003 12:42 PM
To: Multiple recipients of list ORACLE-L

Hi List,

I am using oracle 9i(9.0.1.0.0) or sun Solaris v2.8 when I run the following commands got this error.

ALTER TABLE TEST1 RENAME COLUMN COL1 TO ID; Here is the error:

ORA-14155: missing PARTITION or SUBPARTITION keyword Any Idea, I was searching in googles but nothing found. Thanks for your help.

Hamid Alavi

Office : 818-737-0526
Cell phone : 818-416-5095

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).