How to export raster to Oracle as BLOB
+17- Contributor
Have a look at the following link:
http://fmepedia.safe.com/articles/How_To/How-to-read-the-contents-of-a-file-into-a-database-BLOB-attribute
Thanks for the reply. I have created and executed the work bench as mentioned in the link specified by you. But getting the following error.
Execution of statement `CREATE TABLE "GRD" ("TEST" BLOB,"RAST" MDSYS.SDO_GEORASTER)' did not succeed; error was `ORA-00902: invalid datatype'. (serverType=`ORACLE8I', serverName=`DEVVERDB', userName=`CONGOB', password=`***', dbname=`')
Oracle Writer: Translation aborted -- rerun specifying "ORACLERASTER_1_START_TRANSACTION 0"
It's the problem with the oracle schema. Now i can able to import some of files to Oracle successfully. Thank you. For some files i'm getting the follwoing error in work bench. I'm using the writer "Oracle Spatial GeoRaster".
Oracle writer: This format cannot support multiple palettes. Consider splitting the raster's bands into several bands with one palette each, or several single band rasters with one palette each. Alternatively, remove all but one palette
+5
It's the problem with the oracle schema. Now i can able to import some of files to Oracle successfully. Thank you. For some files i'm getting the follwoing error in work bench. I'm using the writer "Oracle Spatial GeoRaster".
Oracle writer: This format cannot support multiple palettes. Consider splitting the raster's bands into several bands with one palette each, or several single band rasters with one palette each. Alternatively, remove all but one palette
What is your writer ?
+43- Safer
If you want to actually write the data as raster (ie to Oracle Spatial GeoRaster) then just set up the translation directly to that format. No transformers necessary.
The example provided is only needed if you want to write the raster to a blob file in an Oracle non-spatial database (or non-raster Oracle Spatial)
+17- Contributor
To write raster to an Oracle database your database needs to have SDO_GEORASTER installed (part of Oracle Spatial). To check this use the command "desc MDSYS.SDO_GEORASTER" in SQL*Plus. It should respond with a description of the SDO_GEORASTER object definition:
Name Null? Type
----------------------------------------- -------- ----------------------------
RASTERTYPE NUMBER
SPATIALEXTENT MDSYS.SDO_GEOMETRY
RASTERDATATABLE VARCHAR2(32)
RASTERID NUMBER
METADATA SYS.XMLTYPE
Reply
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.