If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Hi guys,
I just find out that my system tablespace is used up to 80%. Please tell me what i should do to free some room of this tbsp without recreating a database. Oracle version 7.1.4 on Unix. Thanks in advance.

1. Check sys.aud$
2. make sure there are no user segments in the tablespace.
3. make sure there are no non-system rollback segments in the SYSTEM tablespace.
4. make sure no users have temporary_tablespace = SYSTEM

If all these scenarios are met, you must add another datafile to the system tablespace.