|
-
Hi , Mr. Thomasps ,
sorry that you totally misunderstood what I mean .
Surely trancate will reset HWM and deallocate all the space (without issuing alter table deallocate command)
But What I mean is after issue delete form table plus issue
alter table deallocate command (do you know the meaning of deallocate ? Please check oracle manual ) , why the hwm is down aroudn 20% ( not 0 % and not 100% , do you think it is strange ?)
Please think again and welcome your reply .
something looks simply but actually not simply :-)
1. www.dbasupport.com
2. www.dbforums.com
3. www.itpub.net
4. www.csdn.net
5. www.umlchina.com
6. www.tek-tips.com
7. www.cnforyou.com
8. fm365.federal.com.cn
9. www.programmersheaven.com
10.http://msdn.microsoft.com/library/default.asp
[email protected]
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
|