最近发现的一个问题,在编辑大量数据的时候,arcGIS报错:无法创建日志文件系统表。用户可能缺少创建表的权限或资源 [Unable to create logfile system tables. User perhaps lacks permissions or resources to create tables] [SDE.GX_PS_PS_POINT][STATE_ID = 36]
ArcGIS平台为 10.2.2
特别注意:在使用此方法后,SDE中添加新数据后不能注册,提示错误为创建索引错误,修改此错误的方法正在研究中。
原因:SDE用户没有穿件共享日志表的权限
解决:
使用基于会话的或独立的日志文件组成的池(Pools of log file tables)
在命令行下,输入以下命令可解决:
sdeconfig -o alter -v MAXSTANDALONELOGS=0 -i sde:oracle11g:orcl -u sde -p sde
sdeconfig -o alter -v ALLOWSESSIONLOGFILE=TRUE -i sde:oracle11g:orcl -u sde -p sde
sdeconfig -o alter -v LOGFILEPOOLSIZE=30 -i sde:oracle11g:orcl -u sde -p sde
如果是SDE服务,则
sdeconfig -o alter -v MAXSTANDALONELOGS=0 -i 5151 -u sde -p sde
sdeconfig -o alter -v ALLOWSESSIONLOGFILE=TRUE -i 5151 -u sde -p sde
sdeconfig -o alter -v LOGFILEPOOLSIZE=30 -i 5151 -u sde -p sde
执行结果
sdeconfig -o alter -v MAXSTANDALONELOGS=0 -i sde:oracle11g:orcl -u sde -p sde
ArcSDE 10.0 for Oracle11g Build 2004 Fri Jan 13 11:45:40 2012
SDE Server Configuration Tool Administration Utility
-----------------------------------------------------
Alter SERVER_CONFIG Table. Are you sure? (Y/N): y
Successfully altered SERVER_CONFIG Table.
sdeconfig -o alter -v ALLOWSESSIONLOGFILE=TRUE -i sde:oracle11g:orcl -u sde -p sde
ArcSDE 10.0 for Oracle11g Build 2004 Fri Jan 13 11:45:40 2012
SDE Server Configuration Tool Administration Utility
-----------------------------------------------------
Alter SERVER_CONFIG Table. Are you sure? (Y/N): y
Successfully altered SERVER_CONFIG Table.
sdeconfig -o alter -v LOGFILEPOOLSIZE=30 -i sde:oracle11g:orcl -u sde -p sde
ArcSDE 10.0 for Oracle11g Build 2004 Fri Jan 13 11:45:40 2012
SDE Server Configuration Tool Administration Utility
-----------------------------------------------------
Alter SERVER_CONFIG Table. Are you sure? (Y/N): y
Successfully altered SERVER_CONFIG Table.