arcGIS编辑报错:无法创建日志文件系统表，用户可能缺少创建表的权限或资源（版本协调时）

原因：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.