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!

Support invisible abstract datatypes (such as invisible SDO_GEOMETRY)

User_1871May 30 2022 — edited May 31 2022

I have a scenario where I need to create an invisible SDO_GEOMETRY column — to hide the column from an application.
19.2.12.1 Understand Invisible Columns
You might use invisible columns if you want to make changes to a table without disrupting applications that use the table. After you add an invisible column to a table, queries and other operations that must access the invisible column must refer to the column explicitly by name.
But when I try to add an invisible SDO_GEOMETRY column to the table, I get an error:

--Oracle 18c
ALTER TABLE ROADS_SDO_INVIS 
        ADD SDO_SHP SDO_GEOMETRY INVISIBLE;

ORA-54041: Visibility of an abstract data type column cannot be changed.
54041. 0000 - "Visibility of an abstract data type column cannot be changed."
*Cause:  An attempt was made to alter the visibility of an abstract data type column.
*Action:  Specify the column visibility change with a supported data type.

Could Oracle add support for invisible abstract datatypes, such as SDO_GEOMETRY?
That would really help. Thanks!

Comments

Post Details

Added on May 30 2022
#active, #general-database-discussions-ideas, #spatial
0 comments
236 views