[postgis-devel] Doubt related to datatype

[Eriovaldo Andrietta]

Hi Frank,

Thanks for your attention.

Well, I had downloaded softwares using link below, but I cannot see OCI when
I try to use ogr2ogr.

Look:

C:\Users\Eriovaldo\Desktop>ogr2ogr
Usage: ogr2ogr [--help-general] [-skipfailures] [-append] [-update] [-gt n]
               [-select field_list] [-where restricted_where]
               [-sql <sql statement>]
               [-spat xmin ymin xmax ymax] [-preserve_fid] [-fid FID]
               [-a_srs srs_def] [-t_srs srs_def] [-s_srs srs_def]
               [-f format_name] [-overwrite] [[-dsco NAME=VALUE] ...]
               dst_datasource_name src_datasource_name
               [-lco NAME=VALUE] [-nln name] [-nlt type] [layer [layer ...]]

 -f format_name: output file format name, possible values are:
     -f "ESRI Shapefile"
     -f "MapInfo File"
     -f "TIGER"
     -f "S57"
     -f "DGN"
     -f "Memory"
     -f "BNA"
     -f "CSV"
     -f "GML"
     -f "GPX"
     -f "KML"
     -f "GeoJSON"
     -f "Interlis 1"
     -f "Interlis 2"
     -f "GMT"
     -f "SQLite"
     -f "ODBC"
     -f "PostgreSQL"
     -f "MySQL"

Tks
Eriovaldo

On Tue, Dec 14, 2010 at 8:28 PM, Frank Warmerdam <warmerdam at pobox.com>wrote:

> On 10-12-14 05:21 PM, Eriovaldo Andrietta wrote:
>
>> Hello Friends,
>>
>>  1.) I am working in order to convert a database with several schemas from
>> Oracle to Postgre/Postgis.
>>  I have some datatypes in Oracle and I would like to know the similar in
>> Postgre.
>>  for example:
>>
>>   timestamp
>>   blob
>>   clob
>>
>>  2.) Also I tried to use the ogr2org tool, as below, to transfer data
>> directly
>> from Oracle to Postgre/Postgis
>>
>>     ogr2ogr -overwrite -f "PostgreSQL" -nln public.tab_f
>> PG:"host=localhost
>> user=postgres password=********  dbname=bdteste"
>>  OCI:eng_sigcamp/********@ora10g:oracle_schema.tab_f
>>
>>  I am running this command and it is not working.
>>  I downloaded the ogr_OCI.dll and I placed it in several folders of  the
>> FWTools.2.4.7 where I imagine that it should be there, unsuccessfully.
>>  I also tried the ODBC configuration and it did not worked.
>>
>>  Is there any clue, where I must place the ogr_OCI.dll ?
>>  Does it work fine ? any experience with this tool.
>>
>> Is there any other tool for doing this data migration.
>>
>
> Eriovaldo,
>
> You cannot use release oriented plugins with FWTools.  FWTools is/was built
> from the development tree and generally should not be mixed with any other
> GDAL/OGR plugins which will inevitably be from other versions.  The plugin
> interface is very fragile and version specific.
>
> Some of the OSGeo4W GDAL/OGR versions include an OCI plugin option - you
> might try that.
>
>  http://osgeo4w.osgeo.org/
>
> 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<http://pobox.com/%7Ewarmerdam>
> and watch the world go round - Rush    | Geospatial Programmer for Rent
>
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20101215/83158426/attachment.html>