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

Posted by ErmanArslansOracleBlog on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/java-sql-SQLException-ORA-20100-ORA-20100-File-o5605765-tmp-creation-failed-tp1366p1382.html

Also please provide the following :

SQL> select o.application_id,
      o.profile_option_name,
      t.user_profile_option_name,
      t.description,
      v.profile_option_value,
      v.level_id
from   FND_PROFILE_OPTIONS_TL t,
      FND_PROFILE_OPTIONS o,
      FND_PROFILE_OPTION_VALUES v
where  o.profile_option_id = v.profile_option_id
and    o.profile_option_name = t.profile_option_name
and    t.language = 'US'
and    v.profile_option_value like '%MEDIA%';

--Note that this time MEDIA in upper CASE ..