I tried using the create or replace directory command and it gave the output as 'Directory Created' but when I checked in D: drive where I created it, I cant find the folder. I am the administrator and my starting drive for SQLplus is also D:/ drive. Any help would be appreciated.
Edited by: 994671 on Mar 18, 2013 10:27 PM
Directory will not be created automatically, You have to create it manually and just give it a reference in your 'create directory' command.
Go to d:\
create a directory manually. lets say test
in sqlplus : create or replace directory test as 'd:\test\'