| Datafile error while inserting data into Oracle 9i database on Windows platform [message #61919] |
Wed, 09 June 2004 23:45  |
Shibaji Ghosh
Messages: 39
Registered: April 2002
|
Member |
|
|
Hello,
I am trying to do some batch operations on Oracle 9i database running in Windows 2000 server. I am witnessing the following errors while inserting.
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01114: IO error writing block to file 11 (block # 2077369)
ORA-01110: data file 11: 'E:ORA_DATAFILECDRTBS01.DBF'
ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
OSD-04026: Invalid parameter passed. (OS 2077369)
The locally managed tablespace has got 4 datafiles each having autoextend set to on, maxsize unlimited. There are enough space on disk, the System tablespace datafile also has space to grow, so is the temp tablespace. But I witness that after growing to a certain extent say (12 GB, sometimes 8 GB), the above mentined errors are witnessed. The other datafiles are not being used. But strangely if I add another datafile then the process runs smooth. But I just cant add on datafiles like that.
To me it seems some kind of Windows error, please clarify on this.
Also, we are yet to test the same on LINUX OS. Please let me know whether we are likely to have the same problem in LINUX too ??
Thanks in advance,
Shibaji
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
