PL/SQL (MOSC)

MOSC Banner

Advice on use of CREATE DIRECTORY

edited Jul 11, 2019 5:02AM in PL/SQL (MOSC) 4 commentsAnswered

Hello All

I hope someone can provide some clarity on the function of the CREATE DIRECTORY command.

Situation is that I have decided to use the BFILE method to enable the delivery of  thousands of relatively small, solely read-only JPGs and PDFs to my Forms 12.2.1.1 forms.  Having read up on the pros and cons of BFILE  v BLOB storage I think the former better suits my needs and the resources I have to sustain the solution, and we're ready for the extra system administration to ensure backup and recovery of the files which will be  external to the database .

So to use these I understand I need to create a DIRECTORY OBJECT, that this needs to be owned by the SYS users, that I'll need to allocate READ only privileges on that object to public (so my users can see the files) and both READ and WRITE privileges to my main admin user so they may upload new images.  I also understand that the CREATE DIRECTORY command does not physically create a directory, (that's my responsibility) and that it's purpose is to hold a synonym for the physical directory in which  I will store my JPGs/PDFs, and that I

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center