Re: ORA-1578 Corrupt database block in Oracle 7

In article <790639889snz_at_jlcomp.demon.co.uk>

           Jonathan_at_jlcomp.demon.co.uk "Jonathan Lewis" writes:

: If the event no longer works, you might reduce the effort of copying by
: working through your table an extent at a time, i.e. look up the
: extent definitions for the table in user_extents (file id, block_id,
: and number of blocks) then for each extent copy the rows where the
: 'file-substr'||'block-substring' is between the starting and ending
: 'file'||'block' for that extent.

I forgot to mention: you have to do this by access through a suitable index (e.g. 'primary key' index') so that the 'file'||'block' gets checked in the index.

-- 
Jonathan Lewis