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: holders <holders_at_demon.co.uk>
Date: 2000/07/25
Message-ID: <397DFC48.FEF16778@demon.co.uk>#1/1

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