My Oracle Support Banner

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 to [Release]
Information in this document applies to any platform.
***Checked for relevance on 12-May-2014***
***Checked for relevance on 09-Nov-2015***


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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.