[postgis-users] ogr2ogr oracle to postgis - emtpy geom column

[ofoerster at posteo.de]

Am 09.01.2018 15:31 schrieb ofoerster at posteo.de:
> Hello community,
> 
> I have the problem that when I migrate from Oracle to PostGIS I get an
> empty geometry column.
> All other data was taken over normally. My PostGIS extension is 
> activated.
> My command is:
> 
> ogr2ogr -a_srs EPSG:25833 -overwrite -f "PostgreSQL" -nln
> public.au_alkis_unit PG:"host=localhost port=5432 user=postgres
> password=postgres dbname=hale_export"
> OCI:"inspire/inspire@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS =
> (PROTOCOL = TCP)(HOST = fb20)(PORT = 1521)))(CONNECT_DATA = (SID
> =fbr))):AU_ALKIS_UNIT"
> 
> Can someone help me?
> 
> For the sake of traceability I have done the Oracle table as SQL dump
> in the attachment.
> 
> best regards, Oli
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users


----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

It is very strange. In the PG Admin, the geometry column is empty. In 
QGIS I can embed the table and the correct geometries are displayed. 
However, the DB Manager of QGIS says that the geometry column has no 
entries.

Please Help.