-
How to release the space in temporary tablespace.I was not able to release it.I tried coalesce pct_icrease 0 and 1.It didnt work.
-
which oracle version are u in,
For dictionary managed tamporary tablespace it would not clear until and unless u restart the database.
-
If you have a temporary segment within, and no user that release it..this is a problem, try this:
change the next extent of the tablespace storage (bigger than the actual) then try coalesce.
let me know
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
|