Please make sure you are using the right versions and installs of Oracle XE Oracle For use of Oracle Spatial functionalities the minimum server and client installation requirements are as follows: Server Oracle Database…

You could probably test to update the spatial metadata and assign NULL to the SRID, I expect you to be able to post then as the error clearly suggests the issue is in the SRID. This SRID does not seem suitable for 3D data, your spatial index was also…