Home » RDBMS Server » Server Administration » ERROR ORA-01114 (Oracle 9i)
ERROR ORA-01114 [message #340966] Fri, 15 August 2008 06:08 Go to next message
manoj12
Messages: 185
Registered: March 2008
Location: India
Senior Member
Dear Sir

I am getting the below error
while trying to fire a select statement

ORA-01114: IO error writing block to file string (block # string)


Well my tablepace size of the user is 155 MB total space.4 MB is free space and used space is 150.8 mb

Also After checking in the dba_temp_files
I can see only one temp file .

SQL> /
FILE_NAME                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            FILE_ID TABLESPACE_NAME                     BYTES     BLOCKS STATUS    RELATIVE_FNO AUT   MAXBYTES  MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  
 ------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------ ---------- ------------------------------ ---------- ---------- --------- ------------ --- ---------- ---------- ------------ ---------- -----------                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  
C:\ORACLE\ORADATA\ubs\TEMP01.DBF                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         1 TEMP                           1.2886E+10    1572992 AVAILABLE            1 YES 3.4360E+10    4194302           80 1.2885E+10     1572864                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           Elapsed: 00:00:00.00
SQL> spool off;


While trying to retrieve the record I am getting the below error.
Please help to resolve the below issue?

Regards

[Updated on: Fri, 15 August 2008 06:26]

Report message to a moderator

Re: ERROR ORA-01114 [message #340979 is a reply to message #340966] Fri, 15 August 2008 06:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64116
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Repost with lines of 80 characters.

Regards
Michel
Re: ERROR ORA-01114 [message #340986 is a reply to message #340966] Fri, 15 August 2008 07:26 Go to previous messageGo to next message
manoj12
Messages: 185
Registered: March 2008
Location: India
Senior Member
Dear Sir

I am getting the below error
while trying to fire a select statement

ORA-01114: IO error writing block to file string (block # string)


Well my tablepace size of the user is 155 MB total space.4 MB is free space and used space is 150.8 mb

Also After checking in the dba_temp_files
I can see only one temp file .

SQL> /
FILE_NAME FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS ------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------ ---------- ------------------------------ ---------- ---------- --------- ------------ --- ---------- ---------- ------------ ---------- -----------

C:\ORACLE\ORADATA\ubs\TEMP01.DBF 1 TEMP 1.2886E+10 1572992 AVAILABLE 1 YES 3.4360E+10 4194302 80 1.2885E+10 1572864

While trying to retrieve the record I am getting the below error.
Please help to resolve the below issue?

[Updated on: Fri, 15 August 2008 07:26]

Report message to a moderator

Re: ERROR ORA-01114 [message #341012 is a reply to message #340986] Fri, 15 August 2008 09:08 Go to previous message
Michel Cadot
Messages: 64116
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Still not correctly post.
There is a "Preview Message" button, use it!

Regards
Michel
Previous Topic: Text from a ddl
Next Topic: Datafile Recovery
Goto Forum:
  


Current Time: Tue Dec 06 02:37:05 CST 2016

Total time taken to generate the page: 0.08651 seconds