Ora 20100 Temp File Creation For FND_FILE Failed

Asked By Kara Gio 10 points N/A Posted on - 06/26/2019

Working on Oracles is mostly a piece of cake. But sometimes when you get stuck on something, it can take forever for you to get out of it. Something similar has happened to me. I started getting the ora 20100 temp file creation for FND_FILE failed error on my database. How can I resolve it?

• Status: Open
• Question Views: 513
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Oracle Database
• Question Tags: Oracle

Answered By Pelayo Lyjputo 0 points N/A #318429

Ora 20100 Temp File Creation For FND_FILE Failed

The ora 20100 error and more similar errors are very common. During processing, Oracle writes some temporary files. Errors like this occur when there is some problem in the processing of the files. They simply tell you that something has gone wrong while processing the files.

In this case, the temp file creation failure error has occurred. This could mean that the system has encountered a problem while performing the write operation of temp files or temporary files.

The solution is simple. Check the directory where the temp files are stored. Check the location of the APPLPTMP on the server. Make sure that your entry in the util_file_dir of your initSID.ora matches the entry on the server.

About Pelayo Lyjputo

Questions
2

Answers
12

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 06/26/2019
• Question Category: Oracle Database