Replacement of the obsolete commande UTL_FILE_DIR

1.1k Views Asked by At

Am a beginner, and i want to use LogMiner in Oracle DB 21c, and in one of the steps was to :

to set UTL_FILE_DIR to use /oracle/database as the directory where the dictionary file is placed

I tried this commande :

alter system set UTL_FILE_DIR = 'PATH' scope = spfile

But i got this error :(commande is obsolete)

enter image description here

Is there a replacement for this commande, and please if you have a site with the rest of the steps to setup Logminer it will help alot.

Site where i found how to setup logminer

1

There are 1 best solutions below

2
On

I'd rather use official documentation.

If you did, you'd see the following note:

Note:Prior to Oracle Database 12c Release 2 (12.2), you used the UTL_FILE_DIR initialization parameter to specify a directory location. However, as of Oracle Database 18c, the UTL_FILE_DIR initialization parameter is desupported. It is still supported for backward compatibility, but Oracle strongly recommends that you instead use directory objects.