How to create UTL_FILE Directory in 19C Database
UTL_FILE is the package PLSQL program can read and write the OS text files It is used to write the custom log files Examples: General debug and temporary files Log and output files generated by concurrent processing 11g R2 and 12c Release 1, We must the UTL_FILE_DIR database initialization parameter to define the directory or directories where these files are located. Oracle Database 18c, the UTL_FILE_DIR database initialization parameter is desupported. Instead of database directory objects are used to specify the locations used for PL/SQL file I/O. The main advantage is no need to DB bounce and directory change will reflect immediately Steps to create the UTL_FILE Step 1 : Query to find the UTL Direcory select name,value from apps.v$parameter where name like 'utl%'; Step 2 : Create new directory Example: mkdir /utlfile/common/sanjeev Step 3 : Export the PERL and PERL5LIB [oracle@vtebs db]$ export PERL5LIB=/oracle/product/19.0.0/db/perl/lib/site_