Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to set/reset the High water mark ?

463428Aug 30 2006 — edited Aug 31 2006
Suppose eg say a table contains 100 records and High water mark will be pointing to the last 100th record.

Suppose I deleted 50 record then where the high water mark will be pointing I guess it will still be pointing to 100th record; then is there any work around to bring it down to 50th record ? so that my execution becomes faster.

If I use truncate It will delete all the record and commit, then i will be loosing 50 record which I in need of ?

Regards,
AAK.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 28 2006
Added on Aug 30 2006
11 comments
1,351 views