Verified if the temp segments are in use but no processes are accessing.
The fix that finally worked is
- drop the tempfile using 'alter database tempfile 'xxx/temp01.dbf' drop including datafiles;
- run rconfig and it worked fine this time
- add tempfile back using 'alter tablespace temp add tempfile size 4000M;
Did notice a few bug reports on Metalink however there's no workaround available so the above should do the trick if you happen run into this issue.
0 comments:
Post a Comment