title: How do I change the SRID's for Oracle SDO_GEOMETRY
body: <p>I have spatial data that Oracle has assigned an SRID of <strong>81989</strong>. I'd like to change it to <strong>27700</strong> - they're both the same coordinate system, its just Oracle uses its own SRID; so no re-projection is necessary (as such <code>SDO_CS.TRANSFORM</code> doesn't work as it actually changes the coordinates too, which I don't want)).</p>
  
  <p>I've updated <code>USER_SDO_GEOM_METADATA</code> easily enough, but the <code>SDO_GEOMETRY</code> containing the data itself has the SRID too and I don't know how to change this.</p>
  
  <p>So for example my current data looks like: </p>
  
  <pre><code>MDSYS.SDO_GEOMETRY(2001,81989,MDSYS.SDO_POINT_TYPE(420531.663898,268911.956161,NULL),NULL,NULL)
  </code></pre>
  
  <p>and I need to go change it to:</p>
  
  <pre><code>MDSYS.SDO_GEOMETRY(2001,27700,MDSYS.SDO_POINT_TYPE(420531.663898,268911.956161,NULL),NULL,NULL)
  </code></pre>
  
  <p>For all rows in a table. But I don't know how to automatically alter a single element in a SDO_GEOMETRY while leaving the other aspects of the array unchanged.</p>
  
  <p>Can anyone point me in the direction? Thanks.</p>