-
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.
Jeff Hunter
-
-
I thought resize was added in 7.2 or 7.3, no?
Jeff Hunter
-
oops, didn't realize that.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|