Re: HELP!!! I filled up my system tablespace!

In article <466nhn$pn0_at_camelot.qdot.qld.gov.au>, jb2_at_qdot.qld.gov.au says...
>
>Matthew M. Lih (matt.lih_at_trw.com) wrote:
>: 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
>
>There is no problem at all in adding datafiles to the system tablespace
>while the database is up and the system tablespace is online. I have
>already done this on O6.0.36 and O7.1.4 on a number of occasions and
>have not had any problems.
>
>Although I don't know what would happen if there were no free extents in
>the system tablespace and the table "DBA_DATA_FILES" needed to be
 extended
>to be able to add the extra datafile. Does oracle allow extents to be
>allocated in a datafile which hasn't been added to "DBA_DATA_FILES"?

The DBA_DATA_FILE is merely a view on internal ORACLE tables. Actually, a datafile is added to the control files, so no extension is needed of any tables within ORACLE. There should be no problem Received on Fri Oct 20 1995 - 00:00:00 CET