FME Version
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>';
Comments
0 comments
Please sign in to leave a comment.