Enterprise geodatabases use log file tables to maintain lists of selected records. Records are written to log file tables for later use by the application in the following situations:
- You (or a tool or other process you run) create a selection set of a specific size—more than 100 records in ArcMap; more than 1,000 records in ArcGIS Pro; more than 1,000 records when Object IDs are requested from a feature service.
- You reconcile or post to a versioned geodatabase.
- A client application checks out data for disconnected editing.
Log file tables store IDs of the selected features so they can be redisplayed. This allows for faster analysis and data processing.
Geodatabases in Oracle use global temporary tables owned by the user who caused the log file table to be created. Users who do not have database permissions to create tables will use global temporary log file tables owned by the sde user.
The following permissions are required for users to create their own global temporary log file tables in Oracle:
- CREATE SESSION
- CREATE TABLE
- CREATE SEQUENCE