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

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

Discover more on this topic