Data import changes user_sdo_geom_metadata

Discussion created by rvrijen on Jun 23, 2011

We use datainterop/fme to load shapes from .DGN files (Bentley Microstation Powerdraft) into our Oracle database. We load the data into a temporary table, which is truncated before each load.

The script works fine... however, during this process the user_sdo_geom_metadata sdo_lb and sdo_ub values for this table are updated with the min/max X and Y values of the data that is being imported. This is unexpected and unwanted behaviour.

IMHO, the view user_sdo_geom_metadata should contain the potential ub/lb values and not the actual values.

Can we control this behaviour with a setting/parameter in datainterop/fme?

Thanks in advance,