Cannot load raster into raster catalog with raster stored in SDO_GEORASTER format in ArcCatalog.
Last Published: August 25, 2014No Product Found
Bug ID Number
NIM006566
Submitted
February 5, 2007
Last Modified
April 2, 2025
Applies to
No Product Found
Version found
9.2
Status
Non-Reproducible
This issue was not reproducible when tested by the development team. Issues may be given this status when they cannot be reproduced or are no longer relevant in a development version of the software, but a specific fix was not installed to address the issue. The issue's Additional Information section may contain further explanation.
Additional Information
No Public Explanation
Workaround
Using command line.The workflow is:2.1 Create raster catalog using command line:----------------------------------------------<a href="file:C:/TEMP" target="_blank">C:\TEMP</a>>sderaster -o import -f tif85.tif -l sdocat1,image -n 85tif -k SDO_GEORASTER -c lz77 -G 20255 -L -1 -i 5151 -u wilson -p wilsonConnecting to server dsgshanpractice, port 5151, as user wilsonArcSDE 9.2 for Oracle10g Build 1105 Wed Dec 6 12:07:10 2006----------------------------------------------------------------Creating user table: sdocat1Creating raster layer: sdocat1.imageImage Dimension..............: 1377, 1652, 3Pixel Type...................: ucharImage Extent.................: minx : 522499.51846139465000 miny : 5254000.24801173060000 maxx : 524999.42536798725000 maxy : 5256999.77294107990000Cell Size....................: x : 1.81679281002369 y : 1.81679281002381Start : Fri Feb 02 15:50:32 2007Time : 00:00:08Raster ID : 1Total Time: 00:00:081 raster(s).Complete...<a href="file:C:/TEMP" target="_blank">C:\TEMP</a>>sderaster -o insert -f tif86.tif -l sdocat1,image -n 86tif -c lz77 -G 20255 -L -1 -i 5151 -u wilson -p wilsonConnecting to server dsgshanpractice, port 5151, as user wilsonArcSDE 9.2 for Oracle10g Build 1105 Wed Dec 6 12:07:10 2006----------------------------------------------------------------Image Dimension..............: 1376, 1652, 3Pixel Type...................: ucharImage Extent.................: minx : 524999.42536798725000 miny : 5254002.06480454090000 maxx : 527497.51548176981000 maxy : 5257001.58973389030000Cell Size....................: x : 1.81679281002368 y : 1.81679281002381Start : Fri Feb 02 15:51:19 2007Time : 00:00:07Raster ID : 2Total Time: 00:00:071 raster(s).Complete...2.2 You can continue inserting more raster data using the sderaster -o insert command as shown in 2.12.3 In ArcCatalog, register this layer (it will be shown as a plain table) with geodatabase. After registered with geodatabase, it will shown as a raster catalogCheck the data type----------------------------<a href="file:C:/TEMP" target="_blank">C:\TEMP</a>>sqlplus wilson/wilsonSQL*Plus: Release 10.2.0.2.0 - Production on Fri Feb 2 15:52:12 2007Copyright (c) 1982, 2005, Oracle. All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsWILSON@orclvm>desc sdocat1; Name Null? Type ----------------------------------------- -------- ---------------------------- NAME VARCHAR2(65) IMAGE SDO_GEORASTER FOOTPRINT NUMBER(38) OBJECTID NOT NULL NUMBER(38)====================================================================================