ORA-1536 On DML Or Running Tools, Applications (Doc ID 1012569.6)

Last updated on NOVEMBER 22, 2016

Applies to:

Oracle Server - Enterprise Edition
Information in this document applies to any platform.

Symptoms

You receive the following error:
ORA-01536, 00000, "space quota exceeded for tablespace '%s'"
// *Cause: The user is attempting to perform an operation which
// requires the creation of a new extent in a tablespace.
// The user has already reached his quota of space in the tablespace.
// *Action: The owner of the tablespace or a privileged user must grant
// additional resource quota on the tablespace to the user.

Like many ORA errors, you can get this error in many different situations. You may get this doing a DML, trying to create an object, running CDE tools, or running an application.

Although you may get this error in different situations, the solution is still the same.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms