With the de-support of UTL_FILE_DIR with Oracle Database 18c. There’s a major behavior change in Oracle 18c/19c: No symbolic links for Data Pump directories.
So if you have created a symbolic link and used it for your database directory in the data pump job, you will face the following error:
ORA-29283: invalid file operation: path traverses a symlink [29433]
As a workaround, set these two underscore parameters to revert to the Oracle 12.2.0.1 and earlier behavior.
ALTER SYSTEM SET “_disable_directory_link_check”=TRUE SCOPE=SPFILE;
ALTER SYSTEM SET “_kolfuseslf”=TRUE SCOPE=SPFILE;
To identify and get rid of all DIRECTORY objects with symbolic links, Oracle has provided the script $ORACLE_HOME/rdbms/admin/utldirsymlink.sql to identify these objects.
Make use of this script and make the necessary changes.
