Re: RENAME COLUMN IN 9I

Hamid,

That should work. Here is the same scenario on 9.2.0.1...

    SQL> create table x (c1 number, c2 number);

    Table created.

    SQL> alter table x rename column c1 to d1;     Table altered.

Just in case your error was a result of your table TEST1 being partitioned, I also tried the following:

    SQL> create table x (c1 number, c2 number) partition by range (c1)       2 (partition p1 values less than (1));

    Table created.

    SQL> alter table x rename column c1 to d1;

    Table altered.

One thing I will suggest is that, if there is any chance that you've encountered any bugs, then 9.0.1.0.0 is where you'll most likely encounter them. I don't think that an older version of 9i was ever made available outside of Oracle Development.

For Solaris8, you can download v9.2.0.2.0 from "http://otn.oracle.com" and then download the 9203 patch from MetaLink to bring yourself up to date. It's all free and it's really easy. Do yourself a favor and just do it...

Hope this helps...

-Tim

on 5/16/03 10:41 AM, Hamid Alavi at hamid.alavi_at_quovadx.com wrote:

> 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
>
>
>
>
>
>
> ======================= Confidentiality Statement =======================
> The information contained in this message and any attachments is
> intended only for the use of the individual or entity to which it is
> addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL
> and exempt from disclosure under applicable law. If you have received
> this message in error, you are prohibited from copying, distributing, or
> using the information. Please contact the sender immediately by return
> e-mail and delete the original message from your system.
> ===================== End Confidentiality Statement =====================
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Gorman
  INET: tim_at_sagelogix.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).