Frequently asked question

Should data be loaded into the SDE user tablespace?

Last Published: April 25, 2020


It is not recommended to load data into the SDE user tablespace.

When the SDE user is created, the SDE user has a default tablespace. The tablespace is designed for the storage of the ArcSDE and Geodatabase schemas. Loading data into the SDE user tablespace is the same to ArcSDE as loading data into the SYSTEM tablespace is to Oracle. It should be avoided.

The storing of spatial data in the SDE user tablespace leads to suboptimal performance of spatial data due to:

- fragmentation of the SDE tablespace.
- potential to crash the ArcSDE if the tablespace fills up.
- possible contention on the storage space.

When a user connects for the first time, the SDE_LOGFILE tables are created to store any user selection. It is not unusual for users to select 100K features. If the SDE user were to make this selection, 100K entries would be written to the log files, potentially in the SDE user tablespace. This should be avoided.

Article ID:000005679

  • ArcMap 8 x
  • Legacy Products

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options