REP-0118: Unable to create a temporary file


Almost the same problem i have found when execute query using form applet when i got this message FRM-41838: Unable to open temporary record buffer file %s.  And then i got this message when i run report. Here the message,

REP-0118 Unable to create a temporary file

The solution i found that maybe help for anyone who face the same problem,

– Check user variables
TEMP and TMP refers to directory that exists, if not exists then you must edit the value

– check free space on the disk, it must be enough space to create temporary file

– delete file in temporary directory, maybe, it cannot be modified because read only or already exists

– check registry setting using REGEDIT, locate variable REPORTS_TMP underkey hkey_local_machine/software/oracle/<oracle home>
make sure the value of the variable refers to exist directory

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: