I am going to be loading some raster layers from a file geodatabase into an Oracle SDE geodatabase, and I am new at managing raster data in the SDE geodatabase so I have a few questions before I begin. All of our data to date has been all vector based.
First I am assuming the layer size in the file GDB should roughly correspond to space needed for SDE so I will be setting up a separate schema, FDS and tablespace(s) devoted to these raster layers (even though they would "logically" group with one of our existing vector datasets) We will be testing several of the layers and we will probably ultimately need a separate SDE geodatabase of it's own and resources for the full layer set after we test on one or two.
First question is the DBTUNE parameters and DEFAULTS for Oracle. Do I need to set these DEFAULTS parameters for oracle (and bounce the SDE service ) after I create these new raster tablespace(s) to enable and use raster data in the geodatabase or would just loading into this new schema and FDS which would be mapped to these new tablespaces suffice?
Also, I see this article http://forums.esri.com/Thread.asp?c=2&f=1722&t=211568 which states that I need a separate tablespace for index and BLK data for rasters, this was for 9.1 and before is it still pertinent now for 9.2 - 10.1 ???
Finally, anthing more I need to know about working with raster data beyond these concerns mentioned?
- ArcSDE 9.2, Oracle 10.2 and Windows 2003 Server
Vango, "you da man!" so I defer to your wisdom -- thanks much,
While the need to split the BLK rows is still wise, I don't know of any sites that are creating new rasters in databases. ArcGIS Server caches have long obviated the need for rasters in the database at all, and Image Server capability getting pushed into the 10.x footprint put rivets in that coffin.
You don't "bounce the SDE service" to manifest DBTUNE changes -- 'sdedbtune' has handled this for many moons.
Is the ArcGIS Server caches and raster posting to the server viable at 9.2 or just at 10.x? Is this process straight forward or need some other licensed component outside of SDE (we have no sites right now, just database repositories and local FGDBs at the moment)
We intend to migrate our entire repository to 10.x SDE and 11g Oracle when our data IA is completed. I will check in the meantime how often these rasters may need to be updated or if this a one time posting.
ArcGIS 9.2 was the cut-off point for most applications of raster-in-database. If you're starting this from scratch, best practice says, "Don't start." Best practice also notes that 9.2 is retired, and 9.3 is on deck.
