SDE数据注册版本后(Regester as versioned)之后,Load或者编辑时出现“Unable to create logfile system tables. User perhaps lacks permission or resources to create tables”
需要修改sdeconfig
详细解决方案请点击下面链接:
http://forums.esri.com/Thread.asp?c=2&f=59&t=131017
查看config
2、修改Config
ArcGIS 9.3里面:
sdeconfig -o alter -v ALLOWSESSIONLOGFILE=TRUE -i service -u sde -p sde_password
sdeconfig -o alter -v LOGFILEPOOLSIZE=20 -i service -u sde -p sde_password
ArcGIS 10.1 SDE:
sdeconfig -o alter -v ALLOWSESSIONLOGFILE=TRUE -i sde:oracle11g:orcl -u sde -p sde
sdeconfig -o alter -v LOGFILEPOOLSIZE=20 -i sde:oracle11g:orcl -u sde -p sde
可以不用上面的sdeconfig,直接plsql用sde账号登录,在sde数据库找到表SERVER_CONFIG,你会发现这个表的3个字段代表了“参数名称”(PROP_NAME),“字符类型参数值”(CHAR_PROP_VALUE)和“数字类型参数值”(NUM_PROP_VALUE)
然后就好办了,找到PROP_NAME字段为ALLOWSESSIONLOGFILE的那行,把NUM_PROP_VALUE字段值设为1,另外再把LOGFILEPOOLSIZE那行设为20