System tbsp out of space

[jn1971]

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.

Jn1971 :(

[marist89]

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.

[Halo]

Or resize the dbf.

[marist89]

I thought resize was added in 7.2 or 7.3, no?

[Halo]

oops, didn't realize that.