How to Change the location of Database Directories

CREATE OR REPLACE DIRECTORY DATA_PUMP_DIR AS '/u04/datapump/ORCL';


Specify OR REPLACE to re-create the directory database object if it already exists. You can use this clause to change the definition of an existing directory without dropping, re-creating, and regranting database object privileges previously granted on the directory.

Users who had previously been granted privileges on a redefined directory can still access the directory without being regranted the privileges.