Home » RDBMS Server » Server Utilities » Reg Exporting a instance from the DB (oracle9i)
Reg Exporting a instance from the DB [message #318849] Thu, 08 May 2008 03:58 Go to next message
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 #318852 is a reply to message #318849] Thu, 08 May 2008 04:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
There is not enough space on the disk.

So add some.

Regards
Michel
Re: Reg Exporting a instance from the DB [message #318863 is a reply to message #318852] Thu, 08 May 2008 05:11 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
Can u tell me whether the disk space is not enough in the drive where we save the file or there is no space on the datafile disk ,can u pls tell me reg this issue

Thanks,
Re: Reg Exporting a instance from the DB [message #318872 is a reply to message #318863] Thu, 08 May 2008 05:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Repost in standard english, I don't understand what you're saying.

Regards
Michel
Re: Reg Exporting a instance from the DB [message #318878 is a reply to message #318872] Thu, 08 May 2008 06:13 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
QUOTE
 There is not enough space on the disk.


Which Disk space?

Thanks,
Re: Reg Exporting a instance from the DB [message #318879 is a reply to message #318878] Thu, 08 May 2008 06:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
data file 23: 'D:\DATA\ORADATA\PRO_DAT01.DBF'

Regards
Michel
Re: Reg Exporting a instance from the DB [message #318881 is a reply to message #318879] Thu, 08 May 2008 06:31 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
Any how i altered the Tablespace and add the another datafile altough same error occurs

Thanks,
Re: Reg Exporting a instance from the DB [message #318887 is a reply to message #318881] Thu, 08 May 2008 06:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
The error is:
Quote:
There is not enough space on the disk.

DISK, DISK, DISK, not file or tablespace.

Regards
Michel
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 messageGo to next message
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

select * 
from  FE_PLUGIN
Re: Reg Exporting a instance from the DB [message #318896 is a reply to message #318887] Thu, 08 May 2008 07:10 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
I think so the Block is Corrupted ,can u tell how can i resolve the corrupted block in the DB

Thanks,
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 messageGo to next message
Littlefoot
Messages: 21823
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
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

Previous Topic: [SQL*Loader] Problems handing over connect string
Next Topic: I Need Answer Urgent
Goto Forum:
  


Current Time: Tue Dec 24 23:49:28 CST 2024