Wednesday, May 11, 2011

CleanUp Temporary Segments Occupying Permanent Tablespace

Recently i did some objects reorganization but i left with some temporary segments occupying space which smon did not drop because the tablespace was READ ONLY. When i made it READ WRITE then the temporary segments dropped. If the problem persists you have by different reason please follow this article : http://askdba.org/weblog/2009/07/cleanup-temporary-segments-in-permanent-tablespace

No comments:

Post a Comment