[Gdal-dev] How to convert an Oracle Spatial Layer to an ESRI Shapefile

[Frank Warmerdam]

Schaminee, L.C.W. wrote:
> How can I convert an Oracle Spatial Layer to an ESRI Shapefile? We have a
> lot of layers under one username. I would like to convert one of these
> layers to an ESRI Shapefile. To do this I used the following command:
> org2ogr -skipfailures -f "ESRI Shapefile" c:\shapefile.shp
> OCI:username/password at database. All of the layers which this user may use
> are being converted. I only want one layer converted. How do I do this? I
> tried this: org2ogr -skipfailures -f "ESRI Shapefile" c:\shapefile.shp
> OCI:username/password at database.layername but this did not work.

Luuk,

Use:

ogr2ogr -skipfailures C:\shapefile.shp OCI:username/password at database layername

You can list one or more layernames at the end of the ogr2ogr command to
operate only on them.  If no layer names are provided, then all layers are
converted.  The format specification isn't strictly required in this case
since shapefile is the default output format.

Best regards,

-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Programmer for Rent