Updating SRID values in an Oracle geometry column

Liz Sanderson
Liz Sanderson
  • Updated

FME Version

  • FME 2015.x

Use the following SQL command in an SQL Statement to Execute after Translation to update the SRID value:

UPDATE <table> a SET a.<geometry_column>.sdo_srid = 90112;

In addition there will be no entry in the user_sdo_geom_metadata table for this second geometry column so you can add an entry by issuing the following command once:

INSERT INTO user_sdo_geom_metadata SELECT TABLE_NAME,'<second_geometry_column_name>',DIMINFO,SRID FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = '<Multi_geometry_table_name>';

Was this article helpful?



Please sign in to leave a comment.