| rename column [message #7381] |
Tue, 10 June 2003 01:36  |
aril
Messages: 11
Registered: June 2003
|
Junior Member |
|
|
hi, i'm a beginner in oracle 9i. i have a problem where i would like to change one of column name in my table. but there always an error message like shown below:
SQL> alter table spj01_peribadi
2 rename column spj01_nama1 to spj01_nama;
rename column spj01_nama1 to spj01_nama
*
ERROR at line 2:
ORA-14155: missing PARTITION or SUBPARTITION keyword
how can i solve this problem. i need somebody to help me with this problem
|
|
|
|
| Re: rename column [message #7382 is a reply to message #7381] |
Tue, 10 June 2003 02:27  |
 |
Maaher
Messages: 7065
Registered: December 2001
|
Senior Member |
|
|
I don't think you're on 9i Rel 2 (which introduced the RENAME COLUMN clause). In my 8.1.5 test DB, I get a similar message. What happens if you do aSELECT Banner
FROM v$version
If the result doesn't state an Oracle 9.2+ version, you cannot rename a column in your version, but you could try with a workaround. Tom Kyte has provided some on his website.
MHE
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
