Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to Compress the "SYSTEM" tablespace
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>...Received on Sun Mar 09 1997 - 00:00:00 CST
>
>
> 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.
>
>