are there any sample sql programs which enable the conversion from SDE.ST_Geometry to SDO_GEometry ?
This isn't a "conversion" exercise as much as a "recreation" one. As such, I doubt there's much to be found (I would never use a script found on the web for my data population needs, so I've never looked). The core of data transfer could be very simple (an INSERT INTO with a SELECT), but creation of the target tables shouldn't be left to chance.
- V