Author: arcsdegeo

ArcGIS 10.2 online web courses

Link arcsdegeoLeave a comment

ArcGIS 10.2 online web courses Esri has started adding ArcGIS 10.2 web courses in their online training website. Esri web courses are very beneficial for people who don’t have the time to take instructor led-courses. these courses can be taken at your time convenience.   Link: http://training.esri.com/gateway/index.cfm?fa=search.results&searchterm=&search=Search&CourseTypeID=1&OrderBy=CourseTitle%20asc&ArcGISVersion=10.2

ArcSDE Geodatabase Maintenance

arcsdegeoLeave a comment

To do a regular ArcSDE Geodatabase Maintenance, you need to do the following:

 

  1. Rebuild Indexes (you can use python scripting for ArcGIS 10.1)
  2. Analyze (update statistics) (you can use python scripting for ArcGIS 10.1)
  3. Compress (you can either use ArcCatalog 10.1 , Command Line, or Python)

 

of course to perform the listed activities you need to have all connections disconnected , which could be a problem if you want to perform maintenance in a “production” environment.

you can schedule these activities either daily or weekly, depends wither your environment is intensive in “editing”, since you will be having a lot of versions.

From practice, ArcSDE Compress will give optimum results when the editors are performing Reconcile and POST and delete their versions. Otherwise, you will not benefit a lot from the compress operation.

Execute privileges on required Oracle builtin package DBMS_UTILITY must be granted directly to the SDE DBA user, granting them a ROLE with execute access is insufficient. ERROR in checking system st_geometry type (-25).

arcsdegeo1 Comment

check my esri forum thread replay: http://forums.arcgis.com/threads/60398-ArcSDE-execute-privilege-be-removed-from-public-on-Oracle-packages?p=329097#post329097

 

be careful in the order of executing the steps.

 

granting the following packages to “PUBLIC” role is always a security issue:

 

dbms_pipe 
dbms_lock 
dbms_lob 
dbms_utility
dbms_sql 
utl_raw

ArcGIS 10.2 Deprecation plan

arcsdegeoLeave a comment

you can find the deprecation plan here: http://downloads2.esri.com/support/TechArticles/W26496_W25918_DEPRECATION_PLAN_FOR_ARCGIS_101_and_102_FINAL_050713.pdf

REMARK: ArcGIS 10.2 will be the last for ArcSDE as an “application server”. This means companies/organizations using ArcSDE tehcnology as an application server, should start migrating to “Direct Connection” , which is a 2-tier architecture.