Skip to Main Content

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

247514
Some information of running Oracle on FreeBSD
http://orafaq.com/faq/is_it_possible_to_run_oracle_on_freebsd

The question of whether Oracle will provide official support need direct to Oracle support.
MohamedTawfik
Hello
I think Oracle Metalink is the better Help for the DBAs only
Regards
Madrid
Oracle is currently officially supported only on

Oracle Enterprise Linux,
Red Hat Enterprise Linux (Red Hat Enterprise Linux family includes Red Hat Enterprise Linux AS, Red Hat Enterprise Linux ES)
SUSE Linux Enterprise Server
Asianux

There are, however underground communities who install on free linux versions, such as Ubuntu, Fedora, debian, just to name a few, on the assumption that those are kernels compatible with supported versions. Those are not supported installation for production environments, but people perform install just for learning or testing.


~ Madrid
1 - 3

Post Details

Added on May 30 2022
0 comments
239 views