SDO_GEORASTER
Description
In the GeoRaster object-relational model, a raster grid or image object is stored in a single row, in a single column of object type
SDO_GEORASTER
in a user-defined table. (Oracle SQL Language Reference SDO_GEORASTER Data Type).
Definition of SDO_GEORASTER object:
CREATE TYPE SDO_GEORASTER AS OBJECT
(rasterType NUMBER,
spatialExtent SDO_GEOMETRY,
rasterDataTable VARCHAR2(32),
rasterID NUMBER,
metadata XMLType);
/
The SDO_GEORASTER
object is not supported in Snowflake.
Sample Source Patterns
SDO_GEORASTER in Create Table
Oracle
CREATE TABLE georaster_table(
georaster_column SDO_GEORASTER
);
Snowflake
CREATE OR REPLACE TABLE georaster_table (
!!!RESOLVE EWI!!! /*** SSC-EWI-0028 - TYPE NOT SUPPORTED BY SNOWFLAKE ***/!!!
georaster_column SDO_GEORASTER
)
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},"attributes":{"component":"oracle"}}'
;
Inserting data in SDO_GEORASTER Table
Oracle
INSERT INTO georaster_table VALUES (null);
INSERT INTO georaster_table VALUES (sdo_geor.init('RDT_11', 1));
Snowflake
INSERT INTO georaster_table
VALUES (null);
INSERT INTO georaster_table
VALUES (
!!!RESOLVE EWI!!! /*** SSC-EWI-OR0076 - TRANSLATION FOR BUILT-IN PACKAGE 'sdo_geor.init' IS NOT CURRENTLY SUPPORTED. ***/!!!
'' AS init);
Known Issues
1. SDO_GEORASTER Data Type not transformed
SDO_GEORASTER Data Type is not being transformed by SnowConvert.
Related EWIs
SSC-EWI-0028: Type not supported.
SSC-EWI-OR0076: Built In Package Not Supported.
Last updated