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: System tablespace - help!

Re: System tablespace - help!

From: Sid_James <sid.james_at_virgin.net>
Date: 2000/07/25
Message-ID: <397E07A7.6F5E@virgin.net>#1/1

There's only SYS using SYSTEM as it's temporary tablespace. I'll change that tomorrow!

Thanks.

holders wrote:
>
> move everybody OFF the system tablespace. If sys is using SYSTEM as its
> temporary tablespace then it wil allocate permanent space on it and there
> will be little you can do about it. What is using the system tablespace ?
> SH
>
> Sid_James wrote:
>
> > On our db only SYS and SYSTEM use SYSTEM as default tablespace, all the
> > others use BESPOKE. SYS uses SYSTEM as its temporary tablespace and
> > SYSTEM uses TEMP.
> >
> > The problem is that the SYSTEM tablespace seems to be using a lot of
> > space far more than usual. Can anyone advise what may be going on?
> >
> > Thx
Received on Tue Jul 25 2000 - 00:00:00 CDT

Original text of this message

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