When adding multiple filenames to the utl_file_dir in Database | Administer | Oracle Parameters the format required by Oracle is incorrect i.e.
1. Database | Administer | Oracle Parameters
2. <Double-click> utl_file_dir
3. add <filename1>,<filename2>
This updates the spfilexxxx.ora with utl_file_dir='<filename1>,<filename2>'
when it should be utl_file_dir='<filename1>','<filename2>'
Toad is not placing quotes round each file name.
WORKAROUND:
1. Database | Administer | Oracle Parameters
2. <Double-click> utl_file_dir
3. add <filename1>','<filename2> ------- Note the ',' between file names
STATUS:
Waiting for fix in a future release of Toad for Oracle
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center