Showing posts with label oracle directory handling. Show all posts
Showing posts with label oracle directory handling. Show all posts

Saturday, October 2, 2010

How to do directory handling in oracle?

create directory ORA_SCOTT_DATA as '/home/scott';
grant read,write on directory ORA_SCOTT_DATA to SCOTT;

Once done with directory you can drop it :-

drop directory ORA_SCOTT_DATA;