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 |
ORA-14042: partition bound may not be specified for a partition being moved, modified or rebuilt
RMAN-07500: searching for all files that match the pattern string
ORA-08463: overflow converting decimal number to Oracle number
ORA-28119: policy group does not exist
ORA-30433: 'string.string' is not a summary
ORA-23422: Oracle Server could not generate an unused job number
ORA-38428: too many attributes selected for indexing
ORA-22888: duplicate SCOPE clauses for a REF column
ORA-23309: object string.string of type string exists
ORA-01425: escape character must be character string of length 1
ORA-36268: (XSCGMDLAGG01) 'string' is not a valid dimension value.
QSM-01077: materialized view, string, is grouping at a higher level than query