I've got a table with sdogeometry object (object relational model) data where the dimension is wrong. The sdo_gtype should be 2003, not 3003 and the sdo_ordinates should contain tuples not triples (third coordinate is always 0).

How can I change the dimension of all geometry data?

Thank you in advance,
Thalion