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-02306: cannot create a type that already has valid dependent(s)
NID-00350: string (number) string
ORA-02447: cannot defer a constraint that is not deferrable
ORA-13786: missing SQL text of statement object "string" for tuning task "string"
ORA-06960: Failed to access log file
LFI-01004: Unable to empty buffer.
ORA-25330: PL/SQL associative arrays may not be used with AQ array operations
ORA-22916: cannot do an exact FETCH on a query with Nested cursors
TNS-00279: Navigator: Failed to Start Tracing
ORA-31193: This versioning feature isn't supported for resource string
RMAN-00700: SCRIPT requires that TARGET be specified on the command line
ORA-16157: media recovery not allowed following successful FINISH recovery