Re: java.sql.SQLException: ORA-20100: ORA-20100: File o5605765.tmp creation failed.

Posted by Roshan on Oct 11, 2016; 9:28am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/java-sql-SQLException-ORA-20100-ORA-20100-File-o5605765-tmp-creation-failed-tp1366p1368.html

Sorry for late reply.

No rows returned for first script

for second script:
SQL> select translate(ltrim(value),',',' ')
from v$parameter
where name = 'utl_file_dir';   2    3

TRANSLATE(LTRIM(VALUE),',','')
--------------------------------------------------------------------------------
/usr/tmp  /D01/Bank/MUR  /D01/Bank/FOREX  /app/PMTG/db/tech_st/11.1.0/appsutil/o
utbound/PMTG_erpprod