ERROR

ORA - 01653: Unable to extend table

Last Published: April 25, 2020

Error Message

When attempting to create a new feature in an Oracle geodatabase, the following error is returned:

Error: 
Error: ORA-01653: unable to extend table

Cause

The Oracle Database Administrator (DBA) USERS table space quota is full.

Solution or Workaround

Use one the following workarounds to fix the error:
  • Create a new data file to compensate for the remainder of the table space. For more information, refer to the following web help document: ArcGIS Desktop: Creating data files in Oracle.
  • Increase the amount of space allowed in the USERS table space using the following sample SQL query:
ALTER USER [username] QUOTA 100M ON [tablespace name]
  • Grant users unlimited table space using the following SQL query sample:
GRANT UNLIMITED TABLESPACE TO [username]
 
 

 

Article ID:000013877

Software:
  • ArcMap

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

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options