ORA-01536 (Space quota exceeded for tablespace "USERS"

[iyyappan]

Hi,

How to solve the problem

ORA-01536 (Space quota exceeded for tablespace "USERS")

Thanks in advance,

Regards,
Iyyappan.M

[pando]

ORA-01536 space quota exceeded for tablespace 'string'

Cause: The space quota for the segment owner in the tablespace has been exhausted and the operation attempted the creation of a new segment extent in the tablespace.

Action: Either drop unnecessary objects in the tablespace to reclaim space or have a privileged user increase the quota on this tablespace for the segment owner

[shaan]

if u don't have sufficient privilleges ask your dba to increase the tablespace quota.

if u r a privilleged user i.e DBA then u can uz
and HDD space is not the issue or u can specify the apace u want to allocate instead of UNLIMITED in terms of K/M bytes

ALTER USER username
IDENTIFIED BY password
QUOTA UNLIMITED ON tablespace_name;

tablespace name should be the users default tablespace