topic Re: Mosaic Dataset storage in ORACLE/SDE in Data Management Questions

Mosaic Dataset storage in ORACLE/SDE

WesKing — Mon, 15 Apr 2013 19:15:43 GMT

Hi Everyone,
I'm creating mosaic datasets to be stored in our Oracle/SDE GIS. In a file geodatabase it is simple to determine the complete size of a mosaic dataset (dataset plus overviews in my case). Our DBA is trying to determine the overall size from these mosaic datasets in Oracle/SDE. He can't seem to find this information. He can find the associated files that Oracle uses (.CAT, .BND, etc.), but he can't find anything that looks like it's storing the overviews (because all files he finds are extremely small). Can anyone direct me how this can be accomplished? Are there SDE commands for mosaic datasets like there are for rasters and layers (SDERaster, SDELayer)?

Thanks in advance,
Wes

Re: Mosaic Dataset storage in ORACLE/SDE

JakeSkinner — Wed, 17 Apr 2013 15:36:09 GMT

Hi Wes,

A mosaic dataset is made up of many tables as you can see. The Overviews will be stored in the "AMD_<dataset name>_OVR" and "SDE_BLK_<RasterColumn_Id>" tables. Overall, a mosaic dataset is made up of the following tables:

AMD_<dataset>_ART
AMD_<dataset>_BND
AMD_<dataset>_CAT
AMD_<dataset>_CSL
AMD_<dataset>_OVR

SDE_AUX_<RasterColumn_Id>
SDE_BLK_<RasterColumn_Id>
SDE_BND_<RasterColumn_Id>
SDE_RAS_<RasterColumn_Id>

To find the RasterColumn_Id, you can run the following query:

select rastercolumn_id from SDE.raster_columns where TABLE_NAME LIKE '%<dataset>%'

When overviews exist, there will be two RasterColumn_Ids. So there will actually be two SDE_AUX, SDE_BLK, SDE_BND, and SDE_RAS tables.

Re: Mosaic Dataset storage in ORACLE/SDE

WesKing — Fri, 19 Apr 2013 21:42:58 GMT

Thanks JSkinn, that worked great.

Wes