Can't find directory created with sqlplus console
I created a directory using the SQLPlus console, but I cannot find it on the file system. Here is the command I used:
SQL> create directory secfile as ’/opt/oracle’;
Directory created.
I looked in my Oracle ( C:\Program Files (x86)\Oracle
) home directory but there is no "images" folder. Where should I look for it?
I am using an Oracle 11g database (installed on my C drive) and I need this directory to store the images that I will be storing in the database. I followed a tutorial on storing images on OracleDB which used the / opt / oracle patch for this directory.
source to share
Everything is different with you. You need to create a directory on the operating system and then create an Oracle directory object using the full path to the operating system directory. The Oracle command create directory
only creates a data dictionary object, it itself does nothing on your server file system. And you cannot use a relative path.
Well, you can create them in any order, but the operating system directory must be created by the time you try to use Oracle alone, so it makes sense for me to create it in the first place.
source to share
The command CREATE DIRECTORY
does not create a directory on your server. It creates a directory object in your Oracle database that serves as a "pointer" (if needed) to a directory on your disk, and as long as any code running in your database (like some PL / SQL code) isn't will try to use the directory object, the database will not know or care if the directory actually exists on disk. You have to create the drive directory using either Windows Explorer or Windows Command Prompt.
Good luck.
source to share