Oracle 18c SDE.ST_GEOMETRY EGDB:
Has anyone ever tried adding additional "attributes" to an ST_GEOMETRY object column?
Such as adding an SDO_GEOMETRY attribute to the object column:
ENTITY | NUMBER(38) |
NUMPTS | NUMBER(38) |
MINX | FLOAT(64) |
MINY | FLOAT(64) |
MAXX | FLOAT(64) |
MAXY | FLOAT(64) |
MINZ | FLOAT(64) |
MAXZ | FLOAT(64) |
MINM | FLOAT(64) |
MAXM | FLOAT(64) |
AREA | FLOAT(64) |
LEN | FLOAT(64) |
SRID | NUMBER(38) |
POINTS | BLOB |
SDO_GEOM | SDO_GEOMETRY |
Source: ST_Geometry in Oracle
Or, alternatively, add an additional "subtype" to the object supertype.
Sure, it wouldn't be supported. But that's not what I'm asking about. I'm asking if anyone has tried it.
Reason: I want to use Oracle Spatial linear referencing functionality, but can't switch my FCs from ST_GEOMETRY over to SDO_GOMETRY. We can't add additional geometry columns to a FC (causes errors). And I want to avoid creating dozens of helper SDO_GEOMETRY FCs if I can help it.
Thanks.