Results 1 to 8 of 8
  1. #1
    Join Date
    Feb 2004
    Location
    Germany
    Posts
    136

    Unanswered: To rename columns

    Hello All!

    How can i rename columns in a table, e.g. from "PERSON_FID" to "ID_PERSON"?
    What is about Constraints on this column?

    Version: Oracle8.1.7
    Regards,
    Julia

  2. #2
    Join Date
    Mar 2004
    Posts
    9

    Re: To rename columns

    Originally posted by julla27
    Hello All!

    How can i rename columns in a table, e.g. from "PERSON_FID" to "ID_PERSON"?
    What is about Constraints on this column?

    Version: Oracle8.1.7
    Hi.

    You cannot rename columns in Oracle 8.1.7 with SQL command. It's possible only in Oracle9i Release 2 and higher.
    For 8.1.7 read this: http://www.devx.com/gethelpon/10MinuteSolution/16591

    Regards

  3. #3
    Join Date
    Mar 2004
    Posts
    15

    alter column name

    I need to alter column name in 9i , how to do it.

    Uday

  4. #4
    Join Date
    Nov 2002
    Posts
    833

    Re: alter column name

    Originally posted by uday bhasker
    I need to alter column name in 9i , how to do it.

    Uday
    alter table x rename column x1 to x2;

  5. #5
    Join Date
    Mar 2004
    Posts
    15
    I tried it, but getting an error as..

    ORA-14155: missing PARTITION or SUBPARTITION keyword

    I havent done any partitions to the table.

    Uday

  6. #6
    Join Date
    Mar 2004
    Posts
    9
    Originally posted by uday bhasker
    I tried it, but getting an error as..

    ORA-14155: missing PARTITION or SUBPARTITION keyword

    I havent done any partitions to the table.

    Uday
    Do you use 9i Release 2 (9.2) ? If not you can't rename columns with SQL command. To check your version: select * from v$version

  7. #7
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up

    Hi,

    Renaming a table column is available only in 9i Release 2. Its not available in 9i Release 1 which is 9.0.1.
    SATHISH .

  8. #8
    Join Date
    Mar 2004
    Posts
    15
    I am using Oracle 9i Enerprise Edition Release 9.2.0.1.0. So I sould be able to rename a column with SQL command.

    Uday

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •