Re: Expanding table space systWG73.dbf?

Hi,

Just check whether the system tablespace is the default tablespace for general user (not SYS, SYSTEM etc) objects. If this is so and create a separate tablespace (CREATE TABLESPACE <TABLESPACE NAME> ....) for non-system users & objects and make this tablespace the default tablespace (ALTER USER <USERNAME> DEFAULT TABLESPACE ...) for the non-system users. Also give space quota on this tablespace to users.

It is likely that the SYSTEM tablespace is the TEMPORARY TABLESPACE for the users. So some of the reports might be creating TEMPORARY segments in SYSTEM tablespace and falling short of space. Change the TEMPORARY TABLESPACE of users to TEMP (ALTER USER <USERNAME> TEMPORARY TABLESPACE TEMP). In my opinion this should take care of your problem. However, if you need to add a datafile you can add it using ALTER TABLESPACE ADD DATAFILE ... command. You can run sqlplus and see help on ALTER TABLESPACE command. This should also give you information on how to extend the tablespace dynamically. Otherwise you can refer SQL language reference manual.

I hope this helps.
Ajit

In article <6adnbu$366_at_saga20.Stanford.EDU>,   fangchin_at_leland.Stanford.EDU (Chin Fang) wrote:
>
> I recently assumed the role of the DBA of an Oracle WorkGroup 7.3
> database server on a Sun machine in my group. Initially I thought the
> table space is autoexpanding, so didn't pay much attention to the
> monitoring of this aspect.
>
> This morning, a colleague informed me via email that he was having
> problems generating certain reports. I used the Oracle Enterprise
> Manager web interface to look at all critical items. One thing
> immediately caught my eyes: the usage of the SYSTEM table space is
> nearly 90%.
>
> How can Oracle claims that this is autoexpanding and yet the usage
> has gone up to 90%?
>
> I would like to solve the problem as soon as possible. I don't
> trust the web interface Oracle Enterprise Manager (used it for back up
> and it didn't do anything good. I resorted to shell script and command
> line svrmgrl instead), so can anyone give me some tips/hints as to what
> I should do in this case. I am willing to dig into the manuals, but
> a pointer to the right direction would be much helpful!
>
> Thanks,
>
> Chin Fang
> fangchin_at_leland.stanford.edu

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet