Reg Exporting a instance from the DB [message #318849] |
Thu, 08 May 2008 03:58 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ram anand
Messages: 244 Registered: February 2008 Location: india
|
Senior Member |
|
|
Hi,
While exporting the datas i got the following error,could pls check over this issue
EXP-00056: ORACLE error 1115 encountered
ORA-01115: IO error reading block from file 23 (block # 366602)
ORA-01110: data file 23: 'D:\DATA\ORADATA\PRO_DAT01.DBF'
ORA-27091: skgfqio: unable to queue I/O
ORA-27070: skgfdisp: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 112) There is not enough space on the disk.
Thanks,
|
|
|
|
|
|
|
|
|
|
Re: Reg Exporting a instance from the DB [message #318890 is a reply to message #318887] |
Thu, 08 May 2008 06:49 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ram anand
Messages: 244 Registered: February 2008 Location: india
|
Senior Member |
|
|
Hi,
This error Shows for the particular table while Exporting
for ex:
. . exporting table FE_PLUGIN
EXP-00056: ORACLE error 1115 encountered
ORA-01115: IO error reading block from file 17 (block # 62777)
ORA-01110: data file 17: 'D:\DATA\ORADATA\FE_SML_DAT01_01.DBF'
ORA-27091: skgfqio: unable to queue I/O
ORA-27070: skgfdisp: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 112) There is not enough space on the disk.
And find the same error while giving select command on the particular table
|
|
|
|
Re: Reg Exporting a instance from the DB [message #318899 is a reply to message #318890] |
Thu, 08 May 2008 07:17 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
"D:\" suggests you use MS Windows.
Open Windows Explorer, go to My Computer, right-click D disk and select "Properties".
Post values of
- capacity
- used space
- free space
[EDIT]Sorry, I should have said "right-click disk which is the target of Export operation" (i.e. disk which is supposed to store export file).
[Updated on: Thu, 08 May 2008 07:19] Report message to a moderator
|
|
|
Re: Reg Exporting a instance from the DB [message #318900 is a reply to message #318887] |
Thu, 08 May 2008 07:17 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
ram anand
Messages: 244 Registered: February 2008 Location: india
|
Senior Member |
|
|
Hi,
I have Anlayzed the tables,i got the same error could pls check over this
FE_PLUGIN
ORA-01110: data file 17: 'D:\DATA\ORADATA\FE_SML_DAT01_01.DBF'
ORA-27091: skgfqio: unable to queue I/O
ORA-27070: skgfdisp: async read/wr
True MASSTDF FE_PLUGIN_PARAMS FE_SML_DAT01 NO NO NO ORA-01115: IO error reading block from file 17 (block # 63673)
ORA-01110: data file 17: 'D:\DATA\ORADATA\FE_SML_DAT01_01.DBF'
ORA-27091: skgfqio: unable to queue I/O
ORA-27070: skgfdisp: async read/wr
select * from FE_PLUGIN
*
Error at line 0
ORA-01115: IO error reading block from file 17 (block # 62777)
ORA-01110: data file 17: 'D:\DATA\ORADATA\FE_SML_DAT01_01.DBF'
ORA-27091: skgfqio: unable to queue I/O
ORA-27070: skgfdisp: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 112) There is not enough space on the disk.
Thanks,
[Updated on: Thu, 08 May 2008 07:19] Report message to a moderator
|
|
|