Forum Stats

  • 3,875,133 Users
  • 2,266,809 Discussions
  • 7,912,089 Comments

Discussions

Support invisible abstract datatypes (such as invisible SDO_GEOMETRY)

User_1871
User_1871 Member Posts: 247 Red Ribbon

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!

Tagged:
User_1871
1 votes

Active · Last Updated