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 |
TNS-12551: TNS:missing keyword
NNL-00257: Server-generated requests currently require authoritative answers
ORA-01539: tablespace 'string' is not online
ORA-28661: Object already has COMPRESS clause specified
DGM-16903: Unable to connect to database
ORA-36200: (XSAGGR34) AGGREGATE operator string requires a WEIGHTBY clause, but ARGS variable workspace object did not specify one.
ORA-06805: TLI Driver: could not send datagram SAP packet for SPX
ORA-02726: osnpop: access error on oracle executable
PCC-00028: Option "string" not legal as EXEC ORACLE OPTION
ORA-01285: error reading file string
NNL-00931: Requests refused, no cached meta-data: number
ORA-01675: max_commit_propagation_delay inconsistent with other instances