-
utl_file_dir parameter
hi,
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,
-
Originally Posted by iris
hi,
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.
-
Originally Posted by iris
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.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
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.
-
Originally Posted by iris
hi,
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|