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
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-lReceived on Fri Jan 15 2010 - 10:37:47 CST