Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Clarify the docs: Abstract datatypes not supported for invisible columns

User_1871May 30 2022

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.

Comments
Post Details
Added on May 30 2022
0 comments
69 views