Re: temporary files

Posted by ErmanArslansOracleBlog on Jul 16, 2020; 4:05pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/temporary-files-tp8513p8516.html

Good..
Yes, you should change the UTL_FILE_DIR to have the same first value as the $APPLPTMP.

And yes, db restart is required for modifying the utl_file_dir.
So, update your spfile and restart your db.