doing more experiments it results that the error is given ONLY when the schema is given.
gdal_translate -of georaster c:\tmp\map.png ^ georaster:geoserver/geoserver,MFDEVDB,GEOSERVER.PASTA _RASTERS,raster ^ -co "INSERT=VALUES(SDO_GEOR.INIT('pasta_rdt_01'))" It is using the table GEOSERVER.PASTA _RASTERS. It would work only once. After that it would give the same error ORA-00955) gdal_translate -of georaster c:\tmp\map.png ^ georaster:geoserver/geoserver,MFDEVDB,PASTA _RASTERS,raster ^ -co "INSERT=VALUES(SDO_GEOR.INIT('pasta_rdt_01'))" It is using the table PASTA _RASTERSThis would work all the time.. Is it working as expected ? On Mon, Jul 12, 2010 at 2:54 PM, Pasta Bolognese <pasta.bologn...@gmail.com> wrote: >> > >> > C:\>gdal_translate -of georaster c:\tmp\map.png >> > georaster:geoserver/geoserver,MFDEVDB >> > >> > and it works well. Then I've imported another immage using the same >> > command and it worked well too ! >> >> Note that you didn't specify table & column so a table named "GDAL_IMPORT", >> column "RASTER" was created for you as default. > > exactly > >> >> > >> > Then I have decided to use a predefined table.... and here the problems: >> > >> > C:\>gdal_translate -of georaster c:\tmp\map.png >> > georaster:geoserver/geoserver,MFDEVDB,geoserver.pasta >> >> This command is missing the column name after "schema.table" so it is >> assuming column name "RASTER" as default. Does the table "pasta" existed >> before that command? > > exactly. The table PASTA is created automatically by the command itself. > >> >> > Input file size is 1014, 863 >> > 0...10...20...30...40...50...60...70...80...90...100 - done. >> > Ouput dataset: (georaster:geoserver,geoserver,MFDEVDB,RDT_33$,33) on >> > PASTA,RASTER >> > > > at this point the table is created by GDAL > >> > C:\>gdal_translate -of georaster c:\tmp\map.png >> > georaster:geoserver/geoserver,MFDEVDB,geoserver.pasta >> > Input file size is 1014, 863 >> > ERROR 1: ORA-00955: name is already used by an existing object >> > ORA-06512: at line 10 >> > >> > ERROR 1: Create Table Error! >> > >> >> Again, this command is missing the column name too, so I believe it is >> trying to re-create the table "Pasta" with column "RASTER". Whatever is >> happening is caused by the error on the command. >> > > At this point GDAL should add a new line to the same table.... > > infact even giving the table name and the column name: (again, the > table is created automatically by GDAL) > > > C:\>gdal_translate -of georaster c:\tmp\map.png > georaster:geoserver/geoserver,MFDEVDB,geoserver.pasta,raster > Input file size is 1014, 863 > 0...10...20...30...40...50...60...70...80...90...100 - done. > Ouput dataset: (georaster:geoserver,geoserver,MFDEVDB,RDT_42$,42) on > PASTA,RASTER > > C:\>gdal_translate -of georaster c:\tmp\map.png > georaster:geoserver/geoserver,MFDEVDB,geoserver.pasta,raster > Input file size is 1014, 863 > ERROR 1: ORA-00955: name is already used by an existing object > ORA-06512: at line 10 > > ERROR 1: Create Table Error! > _______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev