I received some files with only coordinates, which had to be loaded into Oracle. It’s not super difficult, but I thought I’d share it anyway. The files contain some comment lines first, easily recognized the the hash (#) as the first character. The rest of the lines are x, y and z separated by spaces, like this:

When I don’t license Oracle spatial, but only want to use Locator (as described in Appendix B of the Spatial User Guide), is it allowed to load the SDO Java classes into the database ($/md/admin/sdoloadj.sql)? Or does loading the Java classes mean that one switches to using Oracle Spatial, and thus requiring a valid license?