ORA-01536: space quota exceeded for tablespace 'string'
Answers were Sorted based on User's Feedback
Answer / guest
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.
Please add more information about this Error
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / chandu
Chandu is online.
you use any of the below sql command.
SQL> Grant connect,dba,resourse to xyz;
OR
SQL> Alter user xyz quota unlimited on tablespace name;
thank you...
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / naveen kumar s
ORA-01536: space quota exceeded for tablespace 'string'
Cause: The space quota for the segment owner in the
tablespace has been exhausted(overfilled) 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(To make existing space available) or have
a privileged user increase the quota on this tablespace for
the segment owner.
| Is This Answer Correct ? | 1 Yes | 0 No |
QSM-02091: mv references a non-repeatable or session-sensitive expression
ORA-01661: tablespace 'string' is already temporary
ORA-28672: UPDATE BLOCK REFERENCES may not be used on a global index
ORA-00099: timed out while waiting for resource, potential PDML deadlock
ORA-14076: submitted alter index partition/subpartition operation is not valid for local partitioned index
ORA-02266: unique/primary keys in table referenced by enabled foreign keys
ORA-01197: thread string only contains one log
ORA-29513: referenced class name too long
ORA-39123: Data Pump transportable tablespace job aborted string
ORA-16559: out of memory at string
DRG-13312: user CTXSYS does not own USER_LEXER stored procedure string
SQL-02138: No external procedure context exists