Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to rename column

User_534TBNov 3 2022

I am attempting to rename a column on a table which it looks like someone misspelled, but Oracle doesn't like the command I am sending.
ALTER TABLE VW_SUBSTANCE_FULL RENAME COLUMN SV_CHARATERISTICS TO SV_CHARACTERISTICS;

Error report -
ORA-23291: Only base table columns may be renamed
23291. 00000 -  "Only base table columns may be renamed"
*Cause:    Tried to rename a column of a non-base table, like object table/
           nested table/ materialized view table.
*Action:   None. This is not allowed.

Obviously it is not allowed, but I've researched and can't find the alternative.
Here is the table SQL:

  CREATE TABLE "M_INFO"."VW_SUBSTANCE_FULL" 
   (    "SUBSTANCE_ID" NUMBER(20,0), 
    "BARCODE" VARCHAR2(765 BYTE), 
    "BCODE" VARCHAR2(765 BYTE), 
    "LOT" NUMBER(10,0), 
    "FW" NUMBER(28,6), 
    "CORE_MOLECULAR_WEIGHT" NUMBER(28,6), 
    "EXACT_MASS" NUMBER(28,6), 
    "SV_CHARATERISTICS" VARCHAR2(720 BYTE), 
    "PROJECT" VARCHAR2(765 BYTE), 
    "VENDOR_CAT_ID" VARCHAR2(765 BYTE), 
    "REGISTRATION_DATE" DATE, 
    "EXTERNAL_CODE" VARCHAR2(720 BYTE), 
    "COMMON_NAME" VARCHAR2(765 BYTE), 
    "SCAFFOLD" VARCHAR2(765 BYTE), 
    "SUBSCAFFOLD" VARCHAR2(765 BYTE), 
    "CRO_CODE" VARCHAR2(720 BYTE)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "M_INFO_D" ;

Any assistance or direction is appreciated.
Attempted to rename a column, but Oracle does not like that action.

This post has been answered by thatJeffSmith-Oracle on Nov 3 2022
Jump to Answer
Comments
Post Details
Added on Nov 3 2022
2 comments
484 views