Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01536: space quota exceeded for tablespace 'string'
- 3 Answers
- 9380 Views
- Bloom Soft Tech, TCS, I also Faced
- E-Mail Answers
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 |
I've got a database (Oracle Database 10g Enterprise Edition Release 10.2.0.2.0) installed on a server. Via the network I try to connect to the database via a frontend DEVELOPER 2000 R 2.1 (SQL*Plus: Release 3.3.4.0.0 ) while connecting to database I've got the following error- message: ORA-12637: Packet receive failed
DRG-11007: multiple stopwords specified
ORA-24801: illegal parameter value in OCI lob function
ORA-22057: bad integer length [string]
ORA-30365: left relation in the JOIN KEY clause cannot be same as right
ORA-23409: could not find an unused refresh group number
ORA-01541: system tablespace cannot be brought offline; shut down if necessary
ORA-02030: can only select from fixed tables/views
ORA-15106: missing or invalid operating system disk locator string
RMAN-06742: platform name 'string' longer than number
IMP-00084: attempt to mix incremental import with user or table import
RMAN-06453: RECOVERABLE may only be used with datafile objects
Oracle Errors 
