| ERROR ORA-01114 [message #340966] |
Fri, 15 August 2008 06:08  |
manoj12
Messages: 210
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 #340986 is a reply to message #340966] |
Fri, 15 August 2008 07:26  |
manoj12
Messages: 210
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
