Hi,
How to solve the problem
ORA-01536 (Space quota exceeded for tablespace "USERS")
Thanks in advance,
Regards,
Iyyappan.M
Printable View
Hi,
How to solve the problem
ORA-01536 (Space quota exceeded for tablespace "USERS")
Thanks in advance,
Regards,
Iyyappan.M
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
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