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 :(
Printable View
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 :(
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.
Or resize the dbf.
I thought resize was added in 7.2 or 7.3, no?
oops, didn't realize that.