Oracle clear waterline without data table

Time:2021-5-8

*: Oracle uses delete to clearly represent the high water mark left after the information

①.alter table tablename enable row movement;
②.alter table tablename shrink space;

 

Truncate table can automatically clear the high water mark

To be verified

Recommended Today

Looking for frustration 1.0

I believe you have a basic understanding of trust in yesterday’s article. Today we will give a complete introduction to trust. Why choose rust It’s a language that gives everyone the ability to build reliable and efficient software. You can’t write unsafe code here (unsafe block is not in the scope of discussion). Most of […]