utlfixdirs.sql

It's a script that comes with every $ORACLE_HOME and it's located in $ORACLE_HOME/rdbms/admin/ folder. It recreates all DBA_DIRECTORIES that are created by Oracle software and should be referencing the current $ORACLE_HOME. We should use it every tim...