Re: corrupt datablocks

Posted by Roshan on Mar 22, 2018; 10:38am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/corrupt-datablocks-tp5391p5462.html

Hi,

I am planning to create a backup of L7STATISTICS as L7STATISTICS_NEW and truncate the original table afterwards.

Why is there a difference between the original table and new one? Is it the data which is corrupted?

SQL> select count(1) from protect.L7STATISTICS_NEW ;

  COUNT(1)
----------
     33748

SQL> select count(1) from protect.L7STATISTICS ;

  COUNT(1)
----------
     33817

Regards,

Roshan