tag:blogger.com,1999:blog-5495812930803469387.post5348915383829922852..comments2010-08-26T06:16:51.497-07:00ITNirvanashttp://www.blogger.com/profile/16667563005338929437noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-5495812930803469387.post-84258064971857297522010-08-26T06:16:51.497-07:002010-08-26T06:16:51.497-07:00Nice explanation, but HWM can also be reset by reorganizing the table ( ALTER TABLE MOVE ), or using the SHRINK commands of ORACLE 10g.FJ Franken (DBA)http://www.blogger.com/profile/14960974918564490086noreply@blogger.comtag:blogger.com,1999:blog-5495812930803469387.post-8769366351534552222009-07-17T01:24:00.113-07:002009-07-17T01:24:00.113-07:00I always love~~ an explanation with picture.<br /><br />Can i ask a question?<br />If we insert data after when HWM already exist, where will the data be inserted? <br /><br />After the data (red block)? <br />Or after the HWM (green block)?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5495812930803469387.post-40860157206220683802009-06-17T23:51:57.400-07:002009-06-17T23:51:57.400-07:00Krishna - Nice Explanation. If possible update it. with oracle 10g. we have segment shrink. instead of truncate.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5495812930803469387.post-13373729487103121132009-01-16T02:48:00.000-08:002009-01-16T02:48:00.000-08:00good oneAmrutahttp://www.blogger.com/profile/02360549487522329283noreply@blogger.com