HWM problems in oracle

Oracle high water level (HWM) problems in oracle high water level (HWM) find a table with a large number of records, before 1 million, such as table test1. Create table test2 as select * from test1 where 1 = 2; insert into test2 select * from test1; force session interruption before the insert operation is complete. In this case, select * from test2; although test2 does not have any records, it takes a long time. Solution: www.2cto.com Method 1: truncate table test2; Method 2: alter table test2 enable row movement;
Alter table test2 shrink space; then execute select * from test2; it should be within 0.1 seconds.
Author sxdtzhp