Skip to Main Content

Database Software

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!

RMAN and High Water Mark...

Gustavo Erthal JrSep 30 2005 — edited Feb 21 2006
Hi,

Am I right about when we use a delete statement to clear a table, the high water mark do not come to the first segment/extent/block. Although, when we use the truncate table statement the high water mark comes to the first segment/extent/block?

If I am correct, when I use RMAN, and in all off my tables I have applied a truncate table statement, my backup piece will be smaller than if I have used delete statement?

Thanks,
Gustavo.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 21 2006
Added on Sep 30 2005
11 comments
2,438 views