Database Administration (MOSC)

MOSC Banner

ORA-19501: read error on file while datapump import

edited Oct 16, 2011 7:02PM in Database Administration (MOSC) 2 comments
Hi Gurus,
Oracle Version : 10.2.0.3
Operating System : Linux

Here when i try to import data pump dump file in the schema it throws below error. Only STMASTER table did not imported but remaining table imported with out any problem

. . imported <font color="red">"VSAA_UAT"</font>.<font color="red">"PDLLIO_STAGE"</font>   1.930 GB 12539277 rows<br/>. . imported <font color="red">"VSAA_UAT"</font>.<font color="red">"ST_LO_TRANS"</font>                    1.398 GB 16708053 rows<br/>ORA-31693: Table data object <font color="red">"VSAA_UAT"</font>.<font color="red">"STMASTER"</font> failed to load/unload and is being skipped due to error:<br/>ORA-31645: unable to read from dump file <font color="red">"/home/oracle/dbdump/QFUNDVSPROD_2011-10-14.dmp"</font><br/>ORA-19501: read error on file <font color="red">"/home/oracle/dbdump/QFUNDVSPROD_2011-10-14.dmp"</font>, blockno 982272 (blocksize=4096)<br/>ORA-27072: File I/O error<br/>Linux Error: 11: Resource temporarily unavailable<br/>Additional information: 4<br/>Additional information: 982272<br/>Additional information: 253952<br/>. . imported <font color="red">"VSAA_UAT"</font>.<font color="red">"VERIG"</font>        

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center