How to add utl_file_dir in database
Step1 : Stop the application services and create physical folder under utl file directory utlfile/common/PROD /outbound/ archive' STEP 2 : Check utl file directory details in database Show parameter utl_file_dir Create utl file directory using below SQL command alter system set utl_file_dir='/utlfile/common/PROD,'/utlfile/common/PROD /outbound','/utlfile/common/PROD /inbound','/utlfile/common/PROD /outbound/archive' scope = spfile; STEP 3 : Shutdown database STEP 4 : Start database STEP 5 : Verify if new directories are visible Show parameter utl_file_dir STEP 6 : Start Application services.