[Oracle-l] RENAME COLUMN IN 9I

[Oracle-l] RENAME COLUMN IN 9I

	Hamid Alavi
	May 16, 2003 at 5:41 pm

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 =====================

Search Discussions

7 responses
Oldest
Nested

Deshpande, Kirti

at May 16, 2003 at 6:27 pm

⇧

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).

reply | permalink

Tim Gorman

at May 16, 2003 at 6:27 pm

⇧

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).

reply | permalink

Ron Rogers

at May 16, 2003 at 6:40 pm

⇧

Hamid,
The syntext is correct. Make sure that you did not make a typo as it
appears that oracle doesn't recognize the word "COLUMN" and the same
command and format is used to rename partitions.
The manual states that you can not combine this command with any other
column command. Is this a stand alone command?
Ron

hamid.alavi_at_quovadx.com 05/16/03 01:41PM >>>

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: Hamid Alavi
INET: hamid.alavi_at_quovadx.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).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ron Rogers
INET: RROGERS_at_galottery.org

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).

reply | permalink

Indy Johal

at May 16, 2003 at 6:57 pm

⇧

Hamid

You are geting the error because of following reason

Table been modified is PArtitioned table
The database version is 9.0.1.x.x as this is not working in this
version but will work in 9.2 and your syntax is going to work in 9.2. Do a
test as I had got the issue some time back

Thanks

Indy Johal

Hamid Alavi
Sent by: root_at_fatcity.com
05/16/03 01:41 PM
Please respond to ORACLE-L

To: Multiple recipients of list ORACLE-L
cc:
Subject: RENAME COLUMN IN 9I

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: Hamid Alavi
INET: hamid.alavi_at_quovadx.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).

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

reply | permalink

Hamid Alavi

at May 16, 2003 at 7:34 pm

⇧

so rename column is not working in 9i release? Strange

-----Original Message-----
Sent: Friday, May 16, 2003 11:27 AM
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).

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: Hamid Alavi
INET: hamid.alavi_at_quovadx.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).

reply | permalink

Deshpande, Kirti

at May 16, 2003 at 7:34 pm

⇧

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).

reply | permalink

Gogala, Mladen

at May 16, 2003 at 7:51 pm

⇧

It will work in oracle 19j.

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:mgogala_at_oxhp.com

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

so rename column is not working in 9i release? Strange

-----Original Message-----
Sent: Friday, May 16, 2003 11:27 AM
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).

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: Hamid Alavi
INET: hamid.alavi_at_quovadx.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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gogala, Mladen
INET: MGogala_at_oxhp.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).

reply | permalink

Related Discussions

Discussion Navigation

view	thread \| post

Discussion Overview

group	oracle-l @
categories	oracle
posted	May 16, '03 at 5:41p
active	May 16, '03 at 7:51p
posts	8
users	6
website	oracle.com

responses	expanded	Hotkey: s
font	variable	Hotkey: f
user style	avatars	Hotkey: a

[Oracle-l] RENAME COLUMN IN 9I

Search Discussions

Related Discussions

6 users in discussion