What did you mean by "dba_directories records shows that i got emp_dir i just created, but i can't see it in my F: drive" .. you gotta create that directory yourself ... go to F drive and create a physical folder with that name