Skip to Main Content
Forums

Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-00904 invalid identifier when dropping generated column

User_77G7LMar 9 2022

Hello,
I have a table that was created as
CREATE TABLE xxx (
"SHAPE" "SDO_GEOMETRY",
"X_VALUE" NUMBER GENERATED ALWAYS AS ((("MDSYS"."SDO_GEOM"."SDO_POINTONSURFACE"("SHAPE",0.005))."SDO_POINT")."X") VIRTUAL ,
"Y_VALUE" NUMBER GENERATED ALWAYS AS ((("MDSYS"."SDO_GEOM"."SDO_POINTONSURFACE"("SHAPE",0.005))."SDO_POINT")."Y") VIRTUAL)
Both X_VALUE and Y_VALUE columns are created from the SHAPE (SDO_GEOMETRY) column, but when I want to drop them with:
ALTER TABLE xxx DROP (X_VALUE, Y_VALUE)
I get the error "ORA-00904: "MDSYS"."SDO_GEOM"."SDO_POINTONSURFACE": invalid identifier". Am I doing something wrong?
This post has been answered by Jonathan Lewis on Mar 9 2022
Jump to Answer

Comments

Processing

Post Details

Added on Mar 9 2022
#general-database-discussions
2 comments
556 views