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!