Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Posts
    67

    Unanswered: Renaming a Column

    Is there a way i can rename a column in Oracle 9i.

    Or should i delete the column and rename the column again.

  2. #2
    Join Date
    Jan 2004
    Posts
    370
    alter table <tablename>
    rename column <old col name> to <new col name>;


    See SQL reference manual

  3. #3
    Join Date
    Jan 2004
    Posts
    67

    Renaming a column

    I am getting missing PARTITION or SUB PARTITION Keyword

    Can you help me out

  4. #4
    Join Date
    Jan 2004
    Posts
    370
    What version of Oracle9i are you running?

    Is there an index on the column?

  5. #5
    Join Date
    Mar 2004
    Posts
    19
    Probably, that column is used in a Patrition/ sub-partition of the table
    -------------
    Pragati Swain

Posting Permissions

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