-
Export Problem - Hanging
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????
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|