Search This Blog

Saturday, December 24, 2011

create an oracle directory

CREATE OR REPLACE DIRECTORY directoryname AS 'complete path'
/
GRANT read, write ON DIRECTORY directoryname TO username
/

The username should already exist, otherwise create one.

No comments:

Post a Comment