AnsweredAssumed Answered

Stuck with Unable to create logfile system tables error

Question asked by bchandra on Mar 27, 2012
Latest reply on Mar 27, 2012 by JDeRose-esristaff
We have a set of users with read-only access and two other users with edit access to the Geodatabase running in Oracle 11g.
The users are unable to select more than 100 features or 2 sets of features. The error pops up saying "Unable to create logfile system tables error. User perhaps lacks permissions or resources to create tables ORA01031". The edit users are able to perform the operation.

Searching through the forums led me to the log file settings.
First tried to set up as per "Shared log files" settings, the error still persists. The current sde_config settings is attached. In the user1 (read only access) schema, i could see 2 tables - sde_logfiles & sde_logfile_data.
Next, i attempted with the option of Pools of log files owned by the ArcSDE administrator too but to no avail.

Could someone point me in the right direction and suggest which is the best possible log file setting for this situation? (Me not being a DBA, bear with me if it sounds silly)