How to create UTL_FILE Directory in 19C Database
UTL_FILE UTL_FILE is a PL/SQL package that allows programs to read and write operating system text files. It is commonly used to write custom log files. Examples General debug and temporary files Log and output files generated by Concurrent Processing In Oracle Database 11g R2 and 12c Release 1, the UTL_FILE_DIR database initialization parameter must be configured to define the directory or directories where these files are located. In Oracle Database 18c and later, the UTL_FILE_DIR database initialization parameter is desupported. Instead, Database Directory Objects are used to specify the locations used for PL/SQL file I/O. Advantage There is no need for a database bounce, and directory changes are reflected immediately. Steps to Create the UTL_FILE Directory Step 1: Query to Find the Existing UTL Directory SELECT name, value FROM apps.v$parameter WHERE name LIKE 'utl%'; Step 2: Create a New Directory at OS Level Example: mkdir /utlfile/common/sanjeev Step 3: Export PERL and ...