Oracle: create directory

Create directory:

create or replace directory [mydir] as ‘C:/temp’

Grant user:

grant read,write on directory [mydir] to [username]

List directory:

select * from dba_directories;