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 |
LSX-00160: invalid substitution group affiliation between "~S" and "~S"
CLSR-00530: Can not get user name
ORA-38437: The ADT "string" may not contain any user methods.
ORA-22865: more than one column specified
PCC-02320: arithmetic expression does not have correct operand types
O2I-00117: Internal error: No message file for component O2U
ORA-19570: file number string is outside valid range of 1 through string
ORA-26529: local store callback term phase failed for 'string.string'
ORA-06736: TLI Driver: server not running
NNL-00959: Time until cache dump to trace file: string
ORA-30558: internal error [string] in function based index
ORA-07480: snchmod: cannot change permissions on ?/dbs/sgalm.dbf.