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 |
DRG-12014: This document is very big - continue operation?
ORA-24195: attemp to retrieve the name list of a map message with size exceeding 1024
QSM-01131: query has ONLY_MULTIMV_REWRITE hint
ORA-12631: Username retrieval failed
ORA-29967: Cannot drop an operator binding with dependent objects
PCC-00138: Result Set Cursors are not implemented in this precompiler
ORA-36810: (XSTBLFUNC05) Analytic workspace object number does not exist.
ORA-32139: Cannot write to the stream
IMP-00046: using FILESIZE value from export file of string
RMAN-06070: DBWR could not identify datafile string
ORA-24504: data length larger than expected
TNS-01097: TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE