Postgre AsBinary within Oracle

164 Views Asked by At

i have to migrate some postgis stuff to oracle database 11.2.

can you tell me the best oracle pendant for postgis AsBinary(Geometry)?

edit: my try.

SDO_UTIL.TO_WKBGEOMETRY(

 geometry IN SDO_GEOMETRY

 ) RETURN BLOB;

DONE

1

There are 1 best solutions below

0
On

Use ogr2ogr with the Oracle Spatial driver. E.g.:

ogr2ogr -f OCI OCI:username/password PG:dbname=databasename