By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,569 Members | 1,350 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,569 IT Pros & Developers. It's quick & easy.

Rename column name

P: 8
How to rename the column?
i entered "alter table student_19104 rename student_marks to stud_marks"
But it's giving error "missing PARTITION or SUBPARTITION keyword "
Aug 7 '07 #1
Share this Question
Share on Google+
4 Replies


debasisdas
Expert 5K+
P: 8,127
that feature is available only in oracle version 10g.
Aug 7 '07 #2

P: 36
How to rename the column?
i entered "alter table student_19104 rename student_marks to stud_marks"
But it's giving error "missing PARTITION or SUBPARTITION keyword "
You have invalid syntax i.e. lack keyword column
Expand|Select|Wrap|Line Numbers
  1. 17:10:58 SQL> desc z
  2.  Name                                      Null?    Type
  3.  ----------------------------------------- -------- --------------------------
  4.  FF                                        NOT NULL VARCHAR2(10 CHAR)
  5.  
  6. 17:58:39 SQL> alter table z rename column ff to gg;
  7.  
  8. Table altered.
  9.  
  10. Elapsed: 00:00:00.21
  11. 17:59:27 SQL> desc z
  12.  Name                                      Null?    Type
  13.  ----------------------------------------- -------- --------------------------
  14.  GG                                        NOT NULL VARCHAR2(10 CHAR)
  15.  
  16. 17:59:30 SQL> 
It is all written in oracle docs and you can find them http://tahiti.oracle.com

Gints Plivna
Aug 7 '07 #3

P: 16
The syntax is

SQL> Alter table <tablename> rename column <old columnname> to <newcolumnname>;

good luck
mala
Aug 8 '07 #4

P: 8
Hey,thanks it's working.
Aug 8 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.