Hi Frank,<br><br>Thanks for your attention.<br><br>Well, I had downloaded softwares using link below, but I cannot see OCI when I try to use ogr2ogr.<br><br>Look:<br><br>C:\Users\Eriovaldo\Desktop>ogr2ogr<br>Usage: ogr2ogr [--help-general] [-skipfailures] [-append] [-update] [-gt n]<br>
[-select field_list] [-where restricted_where]<br> [-sql <sql statement>]<br> [-spat xmin ymin xmax ymax] [-preserve_fid] [-fid FID]<br> [-a_srs srs_def] [-t_srs srs_def] [-s_srs srs_def]<br>
[-f format_name] [-overwrite] [[-dsco NAME=VALUE] ...]<br> dst_datasource_name src_datasource_name<br> [-lco NAME=VALUE] [-nln name] [-nlt type] [layer [layer ...]]<br><br> -f format_name: output file format name, possible values are:<br>
-f "ESRI Shapefile"<br> -f "MapInfo File"<br> -f "TIGER"<br> -f "S57"<br> -f "DGN"<br> -f "Memory"<br> -f "BNA"<br> -f "CSV"<br>
-f "GML"<br> -f "GPX"<br> -f "KML"<br> -f "GeoJSON"<br> -f "Interlis 1"<br> -f "Interlis 2"<br> -f "GMT"<br> -f "SQLite"<br>
-f "ODBC"<br> -f "PostgreSQL"<br> -f "MySQL"<br><br>Tks<br>Eriovaldo<br><br><div class="gmail_quote">On Tue, Dec 14, 2010 at 8:28 PM, Frank Warmerdam <span dir="ltr"><<a href="mailto:warmerdam@pobox.com" target="_blank">warmerdam@pobox.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div><div></div><div>On 10-12-14 05:21 PM, Eriovaldo Andrietta wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Hello Friends,<br>
<br>
1.) I am working in order to convert a database with several schemas from<br>
Oracle to Postgre/Postgis.<br>
I have some datatypes in Oracle and I would like to know the similar in Postgre.<br>
for example:<br>
<br>
timestamp<br>
blob<br>
clob<br>
<br>
2.) Also I tried to use the ogr2org tool, as below, to transfer data directly<br>
from Oracle to Postgre/Postgis<br>
<br>
ogr2ogr -overwrite -f "PostgreSQL" -nln public.tab_f PG:"host=localhost<br>
user=postgres password=******** dbname=bdteste"<br>
OCI:eng_sigcamp/********@ora10g:oracle_schema.tab_f<br>
<br>
I am running this command and it is not working.<br>
I downloaded the ogr_OCI.dll and I placed it in several folders of the<br>
FWTools.2.4.7 where I imagine that it should be there, unsuccessfully.<br>
I also tried the ODBC configuration and it did not worked.<br>
<br>
Is there any clue, where I must place the ogr_OCI.dll ?<br>
Does it work fine ? any experience with this tool.<br>
<br>
Is there any other tool for doing this data migration.<br>
</blockquote>
<br></div></div>
Eriovaldo,<br>
<br>
You cannot use release oriented plugins with FWTools. FWTools is/was built<br>
from the development tree and generally should not be mixed with any other<br>
GDAL/OGR plugins which will inevitably be from other versions. The plugin<br>
interface is very fragile and version specific.<br>
<br>
Some of the OSGeo4W GDAL/OGR versions include an OCI plugin option - you<br>
might try that.<br>
<br>
<a href="http://osgeo4w.osgeo.org/" target="_blank">http://osgeo4w.osgeo.org/</a><br>
<br>
Best regards,<br>
-- <br>
---------------------------------------+--------------------------------------<br>
I set the clouds in motion - turn up | Frank Warmerdam, <a href="mailto:warmerdam@pobox.com" target="_blank">warmerdam@pobox.com</a><br>
light and sound - activate the windows | <a href="http://pobox.com/%7Ewarmerdam" target="_blank">http://pobox.com/~warmerdam</a><br>
and watch the world go round - Rush | Geospatial Programmer for Rent<br>
<br>
_______________________________________________<br>
postgis-devel mailing list<br>
<a href="mailto:postgis-devel@postgis.refractions.net" target="_blank">postgis-devel@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-devel" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-devel</a><br>
</blockquote></div><br><div style="padding: 0px; margin-left: 0px; margin-top: 0px; overflow: hidden; word-wrap: break-word; color: black; font-size: 10px; text-align: left; line-height: 130%;">
</div>
<div style="visibility: hidden; left: -5000px; position: absolute; z-index: 9999; padding: 0px; margin-left: 0px; margin-top: 0px; overflow: hidden; word-wrap: break-word; color: black; font-size: 10px; text-align: left; line-height: 130%;" id="avg_ls_inline_popup">
</div>