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 |
IMP-00031: Must specify FULL=Y or provide FROMUSER/TOUSER or TABLES arguments
LFI-00109: Unable to open file [string][string]. string.
ORA-00368: checksum error in redo log block
TNS-12204: TNS:received data refused from an application
NNL-00580: register_ns: <name server> <address> <domain>
QSM-01013: nested aggregates or CONNECT BY/START WITH clause present
ORA-16503: site ID allocation failure
ORA-12634: Memory allocation failed
ORA-29917: cannot lock a table which gets its rows from a collection operand
ORA-32037: unsupported use of LEVEL in membership condition
ORA-01699: tablespace 'string' is being imported for point in time recovery
TNS-00123: Unable to perform a listen on configured ADDRESS(es)