找不到使用sqlplus控制台创建的目录 [英] Can't find directory created by using sqlplus console

问题描述

我使用SQLPlus控制台创建了一个目录，但是我无法在文件系统上找到它。这是我使用的命令：

I created a directory using SQLPlus console but I cant find it on file system. Here is the command I used:

SQL> create directory secfile as ’/opt/oracle’;

Directory created.

我看过我的Oracle主目录（ C：\Program Files （x86）\Oracle ），但没有'images'文件夹。
我应该在哪里寻找？

I have looked in my Oracle home directory(C:\Program Files (x86)\Oracle) but there is no 'images' folder. Where should I look for it?

我正在使用Oracle 11g数据库（安装在我的C盘），我需要这个目录来存储图片我将进一步存储在数据库中。我正在关于在OracleDB上存储图片的教程，其中使用'/ opt / oracle'补丁用于该目录。

I'm using Oracle 11g Data Base(installed on my C drive) and I need this directory to store pictures which I will be further storing in the data base. I was following a tutorial about storing pictures on OracleDB in which ’/opt/oracle’ patch were used for that directory.

推荐答案

你有错误的方法。您需要在操作系统中创建一个目录，然后使用操作系统目录的完整路径创建一个Oracle目录对象。 Oracle 创建目录命令只创建一个数据字典对象，它本身本身不会在您的服务器的文件系统上执行任何操作。你不能使用相对路径。

You have things the wrong way around. You need to create a directory in the operating system, and then create an Oracle directory object using the full path to the operating system directory. The Oracle create directory command only creates a data dictionary object, it does not itself do anything on your server's file system. And you can't use a relative path.

嗯，你可以按照任何顺序创建它们，但操作系统目录必须有是在您尝试使用Oracle的时候创建的，所以对我来说，首先创建它更有意义。

Well, you can create them in either order, but the operating system directory has to have been created by the time you try to use the Oracle one, so to me it makes more sense to create that first.

这篇关于找不到使用sqlplus控制台创建的目录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！