Oracle database directory is used when uploading lobs into the database. When we need to do this, the file must be stored in the database directory and the reference given during lob upload.
The database directory is a physical directory on the machine where the database is running.
DBA_DIRECTORIES table has data for all the directories .
To add a new directory in the database , need to run the following as SYS user
CREATE DIRECTORY MY_DIR AS ‘/home/database/mydir’;
Advertisement
