FRM-41839 Occurs when Querying Large Number of Rows and the Temporary File Size Grows Beyond 2GB (Doc ID 970318.1)

Last updated on JULY 04, 2017

Applies to:

Oracle Forms - Version 10.1.2.3.0 to 10.1.2.3.0 [Release 10.1.2.3]
Information in this document applies to any platform.
***Checked for relevance on 12-May-2014***
***Checked for relevance on 09-Nov-2015***

Symptoms

This problem can occur when attempting to execute a query in a form that returns large number of rows if the temporary file size increases beyond 2GB.  The error returned is ->
FRM-41839: Disk I/O error on temporary record buffer file /var/tmp/AAA6Gay8d.TMP

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms