Re: HELP!!! I filled up my system tablespace!
Date: 1995/10/07
Message-ID: <456rbg$gne_at_venice.sedd.trw.com>#1/1
In article <455qjo$e05_at_ddi2.digital.net>, dhudson_at_digital.net (Don Hudson) says:
>Matthew M. Lih (matt.lih_at_trw.com) wrote:
>: How do I add storage to my system tablespace?! I'm at 97% utilization!
>: Folks at Oracle and elsewhere said 20M ought to be plenty, but
>: I just looked at other resources which suggest 70M is more like
>: it.
>Look at the 'alter tablespace <ts_name> add datafile <df_name> size <xxx>M'
>command this will add an additional file to the tablespace increasing the
>total tablespace. Note that the df_name is system dependent. Also the
[snip]
Me again. I thought I read in the documentation that you have to go through a special procedure to add to the system tablespace, as you can't add to it while the database is up. Unfortunately, the documentation was kind of fuzzy, and I can't find it now!
Matthew M. Lih Received on Sat Oct 07 1995 - 00:00:00 CET