Creating a directory in the DB is just a logical link. You still need to create the directory yourself from the OS. Don't forget the directory must be accessibe by Oracle.
And remember the directory must be found by the database OS user, meaning it must be found on the db server itself (ignoring a fileshare that the db server can access that really sits on the clients computer - violating client server principles)
Got it, thanks.
I have created an 'extdir' directory with Path as 'C:extdir'. But I cannot see a folder 'extdir' or 'mydir' being created on C drive.
Correct - like most people you can NOT see objects that don't exist.
If you want a folder you have to create one.
It is all explained in the Oracle docs.
A directory object specifies an alias for a directory on the server file system where external binary file LOBs (
BFILEs) and external table data are located.
. . .
For file storage, you must also create a corresponding operating system directory, an Oracle Automatic Storage Management (Oracle ASM) disk group, or a directory within an Oracle ASM disk group.
See that word 'alias' in the first sentence?
See that 'you must also create ...' in the second paragraph.
1. you don't have a dog but decide to get
2. you will call the dog 'barky'
3. you buy a collar with a name tag and you write 'barky' on the name tag.
What color is your dog 'barky'?
Oops! You forgot to go to the shelter to pick out a dog.