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

1960
2
10-30-2015 09:59 AM
Highlighted
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
Highlighted
Regular Contributor III

What type of Oracle Log files are you people using?

https://desktop.arcgis.com/en/desktop/latest/manage-data/gdbs-in-oracle/logfiles-oracle.htm

Geodatabases in Oracle use shared log file tables by default.

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

  • CREATE SESSION
  • CREATE TABLE
  • CREATE SEQUENCE

This will create the necessary log file.

Highlighted
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

Reply
0 Kudos