Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01536: space quota exceeded for tablespace

Re: ORA-01536: space quota exceeded for tablespace

From: Ose <R.Osenberg_at_keh-berlin.de>
Date: 2000/05/23
Message-ID: <8gd5ea$6co$1@unlisys.unlisys.net>#1/1

Thank you for your answer, I think I mixed up quota and free space. Reinhard Osenberg.

Michel Cadot <micadot_at_netcourrier.com> schrieb in im Newsbeitrag: 8gba3e$dip$1_at_news6.isdnet.net...
> You have no more quota on this tablespace, this is
> independent of having no space left:
>
> ORA-01536 space quota exceeded for tablespace 'string'
> 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.
>
> --
> Have a nice day
> Michel
>
>
> Ose <R.Osenberg_at_keh-berlin.de> a écrit dans le message :
 8gb7kd$klc$1_at_unlisys.unlisys.net...
> > I got the Message:
> > ORA-01536: space quota exceeded for tablespace RT_DATA
> > But I have 200 MB free space for the dbf, only 1,27 MB of the 200 MB
 used by
> > "RT_DATA"
> > What to do??
> > Reinhard Osenberg
> >
> >
> >
>
>
Received on Tue May 23 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US