|
|
FRM-41839: Disk I/O error on temporary record buffer file %s
tips
Oracle Error Tips by Stephanie Filio of Burleson Consulting
|
Oracle documents offer this information
regarding FRM-41839:
FRM-41839: Disk I/O error on temporary
record buffer file %s
Cause: An
I/O error occurred on attempting to read or write a record to the temporary
record buffer file.
Action: Verify that
the file system or directory in which the file resides exists, and that you have
permissions to read and write to it, and that it contains sufficient space.
Internet sources
offer information regarding FRM-41839 in Oracle
Forms, Version 10.1.2.0.2 on any platform. The document advises
that an Oracle user should, "set the TMP ( For Windows) and TMPDIR ( For
UNIX) environment variable in their default.env file to a valid directory with
sufficient space." to avoid error FRM-41839.
Another
user encountered FRM-41839 "when accessing
the discrepancy database." In cases such as these, you may want to
consider:
This is a known Forms issue that can
occur when a query is executed which
will return a large number of records and disk space is limited.
The error is raised when Forms is trying to create a temporary file
which
will store the results of the query but there is not enough free disk
space
available (on the drive which is assigned to TEMP/TMP).
Either free up enough space on this drive to allow the temporary file to
be
created or move the contents of the TEMP directory to a different drive.