Skip to main content
  • EN

I have a "mapinfo" table that I'm trying to load into a oracle DB with SDO_Geometry. My license doesn't let me create a writer in FME as an Oracle Spatial table. So my workaround is to add the tables as "oracle non-spatial" tables. This works fine for address points but when I run the following SQL;

This updates successfully. The issues is when I check in "Data Inspector" if its saved correctly (for this particular record which is a multipolygon).

 

I get only one of the polygon objects returning;

Hi @thomastupuivao,

Could you try this SQL instead?

 

UPDATE test_postcode SET geoloc = sdo_geometry(wkb,335872);

Hi @thomastupuivao,

Could you try this SQL instead?

 

UPDATE test_postcode SET geoloc = sdo_geometry(wkb,335872);

hi @steveatsafe, that worked!! thanks for that! appreciate it.

hi @steveatsafe, that worked!! thanks for that! appreciate it.

Awesome!!

hi @steveatsafe, that worked!! thanks for that! appreciate it.

@thomastupuivao,

A couple of other things for your Oracle Database:

Make sure spatial_vector_acceleration=true.

What database release are you running? You might want to see if you are on the latest spatial merge patch.

Also, in case you didn't know - Spatial and Graph is now included in the database at no extra cost (as of Dec 2019).

Reply


Community Stats

30,194
Posts
114,615
Replies
37,857
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.