i have a table named dept.
first i insert a lot of row and then delete it.
so high water mark is higher than it should be.
i should rebuild the table.
also i have a table emp and have a foreign key to dept.
question: how to rebuild dept ONLINE?
one choice is export and import.
another choice is create table as select.
1.
if we export and import.
we need first disable foreign between dept and emp.
then we truncate table dept or drop table dept.
question:if somebody insert some record into emp which refer
to noexist deptno, what happen?
2.
same thing for choice two.
can somebody tell me the detail of how to rebuild in order to
reset high water mark ONLINE?