Can't Edit More than 100 Records At Once - Oracle

10-30-2015 09:59 AM
Occasional Contributor

We are unable to edit a geodatabase in Oracle if we select more than 99 records at once. We get the following error: "Unable to create logfile system tables. User perhaps lacks permissions or resources to create tables."

Our DBAs are pretty tight on permissions and privileges so 'UNLIMITED_TABLESPACE' is not an option for standard users. What privileges and tablespace size should editors have in Oracle to be able to edit large datasets?

We're running ArcGIS 10.3.1 on Oracle 12c instance.

2 Replies
Regular Contributor III

What type of Oracle Log files are you people using?

Geodatabases in Oracle use shared log file tables by default.

Try granting these three permissions and then try to select more than 99 records:


This will create the necessary log file.

Occasional Contributor III

ArcGIS needs to create 2 tables, 4 indexes, and 1 sequence. This will be done the 1st time the user selects more than 100 features from a feature class. At that point, you should be able to revoke the CREATE TABLE and CREATE SEQUENCE permissions.

I had a similar question with similar DBA concerns and go into it in a little more detail:Oracle Read-Only User 10.2

0 Kudos