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-29823: object being analyzed is not a table
NNL-00351: Scheduled configuration save to occur in string
ORA-01511: error in renaming log/data files
AMD-00148: Workspace "string" is not currently open. No update done.
SQL*Loader-00952: Error calling once/data file initialization
ORA-25205: the QUEUE string.string does not exist
ORA-07683: sou2os: $SETPRV reset error
DRG-12430: mandatory argument missing: string
NNL-00808: Queries received, all user-defined types: number
AMD-00143: View name "string" must be fully qualified with the Owner.
ORA-01429: Index-Organized Table: no data segment to store overflow row-pieces
SQL*Loader-00517: Error decomposing file name (string)