Re: impdp "failed to load/unload" master table

From: Nigel Thomas <nigel.cl.thomas_at_googlemail.com>
Date: Fri, 15 Jan 2010 16:37:47 +0000
Message-ID: <53258cd51001150837m71803876i68987443130fcb08_at_mail.gmail.com>



Masha

To see if it is a filesize problem, try reading the block that Oracle objected to (ie block number 1048229 in dump file "/u04/exports/prod8/expdat.dmp") using an O/S tool like dd.

What size is your filesystem block? 2**10 (1024*1024) = 1048576, so this block number would be fairly close to 2GiB if your filesystem block were 2K.

Of course it could be a simple file corruption... Did you compress the file? did you transfer it using ftp in ascii mode? But you might expect a different error message for that.

Regards Nigel

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jan 15 2010 - 10:37:47 CST

Original text of this message