I am trying to use ogr2ogr to copy data from Oracle spatial to PostgreSQL. My command line is:
OGR2OGR -overwrite -f "PostgreSQL" -s_srs 141122 -t_srs 4326 PG:"host=localhost user=Postgres password=xxxxxx dbname=penngis" OCI:"GEOADMIN/geoadmin@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.117.244)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=penngis))):GEOADMIN.RMSSEG" -nln orci_rmsseg In the log I see: OGR: Auto register C:\Program Files\GDAL\gdalplugins\ogr_OCI.dll using RegisterOGROCI. OCI: Userid=GEOADMIN, Password=geoadmin, Database=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.117.244)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=penngis))) ERROR 1: in <unnamed> FAILURE: Unable to open datasource `OCI:GEOADMIN/geoadmin@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.117.244)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=penngis))):GEOADMIN.RMSSEG' with the following drivers. -> OCI -> ESRI Shapefile ... It seems it registers the OCI plugin but does not seem to attempt a database connection. Any ideas what I may be doing wrong? David -- David R Robison Open Roads Consulting, Inc. 103 Watson Road, Chesapeake, VA 23320 phone: (757) 546-3401 e-mail: [email protected] web: http://openroadsconsulting.com blog: http://therobe.blogspot.com book: http://www.xulonpress.com/bookstore/bookdetail.php?PB_ISBN=9781597816526 This email communication (including any attachments) may contain confidential and/or privileged material intended solely for the individual or entity to which it is addressed. If you are not the intended recipient, please delete this email immediately. _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
