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: How to Compress the "SYSTEM" tablespace

Re: How to Compress the "SYSTEM" tablespace

From: AMARENDRA B NETTEM <nettama_at_charlie.cns.iit.edu>
Date: 1997/03/09
Message-ID: <01bc2c81$356e36b0$8ba757c6@vanaja>#1/1

The solution is create TEMPORARRY TABLESPACE..

-- 
    AMARENDRA B NETTEM
    ORACLE CONSULTANT
    WHITTMAN-HART INC., CHICAGO
    (http://www.iit.edu/~nettama)

kitty_at_tpts1.seed.net.tw wrote in article <5fot62$jsr_at_reader.seed.net.tw>...

>
>
> The Error message is
>
> ORA-01652 :
> unable to extend temp segment by 5120 in tablespace SYSTEM
>
> I altered the tablespace by adding a 10M datafile, but the error
> message still shows up
>
> Should I compress system talbesapce? If the answer is YES, then how
>
> If there are other situation that may casue this problem
>
>
> Thank you in advance for your help.
>
>
Received on Sun Mar 09 1997 - 00:00:00 CST

Original text of this message

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