Home » SQL & PL/SQL » SQL & PL/SQL » rename column (oracle 10g)
rename column [message #390730] Mon, 09 March 2009 08:22 Go to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
hi,
when i used the following query it is throwing exception like
alter table emrbloodglucosedetails rename column vnew to results
/
exception: SQL Error: ORA-23290: This operation may not be combined with any other operation
then how to rename a column
Re: rename column [message #390731 is a reply to message #390730] Mon, 09 March 2009 08:27 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

SQL> desc tst
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 A                                                  NUMBER(38)

SQL> alter table tst rename column a to b;

Table altered.

SQL> desc tst
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 B                                                  NUMBER(38)


Quote:
ORA-23290: This operation may not be combined with any other operation
Cause: ALTER TABLE RENAME COLUMN/CONSTRAINT operation was given in conjunction with another ALTER TBALE Operation. This is not allowed.
Action: Ensure that RENAME COLUMN/CONSTRAINT is the only operation specified in the ALTER TABLE.


check your constraints..

Babu

[Updated on: Mon, 09 March 2009 08:31] by Moderator

Report message to a moderator

Re: rename column [message #390732 is a reply to message #390730] Mon, 09 March 2009 08:28 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oracle
ORA-23290: This operation may not be combined with any other operation

Cause: ALTER TABLE RENAME COLUMN/CONSTRAINT operation was given in conjunction with another ALTER TBALE Operation. This is not allowed.

Action: Ensure that RENAME COLUMN/CONSTRAINT is the only operation specified in the ALTER TABLE.

Because, it works just fine:
SQL> alter table test rename column loc to location;

Table altered.

SQL>
Previous Topic: 'JSP'
Next Topic: Query checker
Goto Forum:
  


Current Time: Sat Dec 10 01:29:06 CST 2016

Total time taken to generate the page: 0.21856 seconds