Hi all,

Oracle Ver : 8.1.7.2
OP : Sun Solaris 2.7

Problem:-

I've tried exporting a table which has 23 million records (3.1gb) twice and both times it hung at the same point - I put feedback on and it stops at 15 million records (587mb - compressed). I've create a pipe and compressing the pipe to my dump file....

Also, when I try and do a select Count(0) from this table the whole db runs very slow, nearly to a halt...

I've tried the dbverify command on each of my datafiles and it reported no corruption... When not selecting on this table the db is fine with no problems at all


Any ideas????