rajusub
25th June 2007, 13:13
Getting Error 2114 while executing 'Easy SQL Query'. The database is Oracle 8 and OS is Unix. the query is working fine with some selection criteria, it gives this error only for full range.

shah_bs
25th June 2007, 18:10
I am assuming that this is the BDB Error number 2114. The corresponding Oracle error number is 1114 and here is its description:


oerr ora 1114
01114, 00000, "IO error writing block to file %s (block # %s)"
// *Cause: The device on which the file resides is probably offline. If the
// file is a temporary file, then it is also possible that the device
// has run out of space. This could happen because disk space of
// temporary files is not necessarily allocated at file creation time.
// *Action: Restore access to the device or remove unnecessary files to free
// up space.


Hope this helps. Else look in the log.oracle8 or log.ora.sql files and get more information on the error.