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

From: Masha Gurenich <gurenich_at_gmail.com>
Date: Fri, 15 Jan 2010 12:50:16 -0500
Message-ID: <ebb6b7321001150950p7832e9c1j294d50a2f3bc529f_at_mail.gmail.com>

awright, i was able to manage it by dropping the dump file and redoing the expdp... whatever was it - (i guess just file corruption) - it's gone and works okay. weird, but at least it's working... O_o

thank you everybody !!!

On Fri, Jan 15, 2010 at 11:37 AM, Nigel Thomas < nigel.cl.thomas_at_googlemail.com> wrote:

> 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 - 11:50:16 CST