what is the function of utl_file_dir parameter in oracle 10g. Does this parameter related to smtp_out_server parameter for sending mails from database.
what is the function of utl_file_dir parameter in oracle 10g. Does this parameter related to smtp_out_server parameter for sending mails from database.
thanks,
[orapreprod@erpnode2 ~]$ sqlplus sysdba/sysdba as sysdba
Connected:
SQL> show parameter utl_file_dir;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
utl_file_dir string /tmp, /usr/tmp
It's pretty much the temp dir and i'm not sure (i personaly don't think) if it has anything to do with the smtp parameter.
what is the function of utl_file_dir parameter in oracle 10g. Does this parameter related to smtp_out_server parameter for sending mails from database.
Ora10g?
utl_file_dir is deprecated, still there for backward compatibility - use Create Directory instead.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
what is the function of utl_file_dir parameter in oracle 10g. Does this parameter related to smtp_out_server parameter for sending mails from database.
thanks,
and no it has nothing to do with the sending emails
a 2 min search in the documentation would have proved this of course
Reply With Quote
Originally Posted by iris
Bookmarks