How to create Oracle directory?

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

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


Grant succeeded.

5 thoughts on “How to create Oracle directory?”

  1. Unquestionably believe that which you stated. Your favorite reason appeared
    to be on the net the simplest thing to be aware of. I say to you, I definitely get irked while people
    think about worries that they just don’t know about.
    You managed to hit the nail upon the top and defined out the whole thing
    without having side-effects , people can take a signal.

    Will probably be back to get more. Thanks

    Look into my webpage … Nordvpn Coupons inspiresensation

  2. Hi there! I know this is kind of off topic but I was wondering which blog platform are you using
    for this site? I’m getting sick and tired of WordPress because I’ve
    had issues with hackers and I’m looking at options for another platform.
    I would be awesome if you could point me in the direction of a
    good platform.

    Also visit my blog :: Nordvpn Coupons Inspiresensation (http://Easyurl.Cc/Nordvpn-Coupons-Inspiresensation-78351)

  3. Wonderful goods from you, man. I’ve understand your stuff previous to and you’re just extremely excellent.
    I really like what you’ve acquired here, really like what you’re
    saying and the way in which you say it. You make it entertaining
    and you still care for to keep it wise. I can’t wait to read far more from you.
    This is really a tremendous site.

    Also visit my site; nordvpn coupons inspiresensation (t.co)

Leave a Reply

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