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;

No comments:

Post a Comment