How to create directories in Oracle Database?

Database Directories are required to read/write to a filesystem location from plsql code.


Below is the syntax to create database directory


SQL> create directory PLSQL_DIR AS ‘/oratmp/code’;


Directory created.


Grant Read/write privileges to Required Schema (e.g . APPS)


SQL> GRANT READ,WRITE ON DIRECTORY PLSQL_DIR TO APPS;


Grant succeeded.

15 thoughts on “How to create directories in Oracle Database?”

  1. Alright, so I gave cwin666 a shot and honestly, it’s not bad! The games are pretty decent and I managed to snag a few wins. Definitely worth checking out if you’re looking for a new spot. Check them out here cwin666.

Leave a Reply

Your email address will not be published. Required fields are marked *