Forum Stats

  • 3,875,128 Users
  • 2,266,809 Discussions
  • 7,912,088 Comments

Discussions

Clarify the docs: Abstract datatypes not supported for invisible columns

Regarding the invisible column docs:

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.

Could information be added to the docs to explain that it's not possible to create an invisible column where the datatype is abstract?

--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.

That would help avoid confusion. Thanks.

Tagged:
User_1871
1 votes

Active · Last Updated