OraFAQ Forum: Server Utilities » Reg Exporting a instance from the DB

Home » RDBMS Server » Server Utilities » Reg Exporting a instance from the DB (oracle9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Reg Exporting a instance from the DB [message #318849]

Thu, 08 May 2008 03:58

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,

Report message to a moderator

Re: Reg Exporting a instance from the DB [message #318852 is a reply to message #318849]

Thu, 08 May 2008 04:16

Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

There is not enough space on the disk.

So add some.

Regards
Michel

Report message to a moderator

Re: Reg Exporting a instance from the DB [message #318863 is a reply to message #318852]

Thu, 08 May 2008 05:11

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,

Report message to a moderator

Re: Reg Exporting a instance from the DB [message #318872 is a reply to message #318863]

Thu, 08 May 2008 05:34

Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Repost in standard english, I don't understand what you're saying.

Regards
Michel

Report message to a moderator

Re: Reg Exporting a instance from the DB [message #318878 is a reply to message #318872]

Thu, 08 May 2008 06:13

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,

Report message to a moderator

Re: Reg Exporting a instance from the DB [message #318879 is a reply to message #318878]

Thu, 08 May 2008 06:25

Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

data file 23: 'D:\DATA\ORADATA\PRO_DAT01.DBF'

Regards
Michel

Report message to a moderator

Re: Reg Exporting a instance from the DB [message #318881 is a reply to message #318879]

Thu, 08 May 2008 06:31

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,

Report message to a moderator

Re: Reg Exporting a instance from the DB [message #318887 is a reply to message #318881]

Thu, 08 May 2008 06:39

Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...

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

Report message to a moderator

Re: Reg Exporting a instance from the DB [message #318890 is a reply to message #318887]

Thu, 08 May 2008 06:49

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

Report message to a moderator

Re: Reg Exporting a instance from the DB [message #318896 is a reply to message #318887]

Thu, 08 May 2008 07:10

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,

Report message to a moderator

Re: Reg Exporting a instance from the DB [message #318899 is a reply to message #318890]

Thu, 08 May 2008 07:17

Littlefoot
Messages: 21809
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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 17 07:04:38 CDT 2024