How To Reset High Water Mark (Oracle SQL PLSQL Tricky Interview Questions)

‪@trickyinterviewquestions‬
What is high watermark and how to reset it?
For other videos-
HTML in SQL Queries
• HTML in SQL Queries (O...
DML Error Logging
• DML Error Logging (Ora...
High Water Mark and Reset Examples
• How To Reset High Wate...
When composite index would be used by Oracle
• When composite index w...
Create Primary Key on Column with Duplicate Values
• Create Primary Key On ...
Difference between Counts
• Difference Between Cou...
Difference between varchar2(char) and varchar2(byte)
• Varchar Data Types And...

[@KrishnaKumar-fc8kl]

Good information sir jee

[@pr-rb6jl]

Thanks for the vital information

[@digvijaydamame7351]

awesome !!!

[@ur8946]

What happen to Highwater mark , when we truncate partition of the table ?

[@trickyinterviewquestions]

Usually each partition would have its own segment, each partition will maintain its own HMV. so if you truncate a partition then its HMV would be reset.

[@ur8946]

Thanks for reply , Could you please explain with some example that will be great.