SDO_GEORASTER ORA-00902: invalid datatype error.
525407Nov 15 2007 — edited Dec 3 2007Hello all,
In an Oracle Database 10.2.0.1 where spatial seems installed as sql returns the sdo_version = 9.2.
Trying to create GeoRaster table is thrown error "ORA-00902: invalid datatype error." on SDO_GEORASTER type.
-------------------------------------------------------------------
-- Create a GeoRaster table (a table that has a
-- column of SDO_GEORASTER object type).
-------------------------------------------------------------------
create table MyGeoRaster
(georid number primary key,
type varchar2(32),
georaster sdo_georaster);
Thanks very much.