Posts

Showing posts from May, 2020

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.