SQL> create or replace directory 6104 as 'd:\temp';
ORA-22929: 无效或遗失的目录名称
SQL> create or replace directory "6104" as 'd:\temp ';
Directory created
Directory created
SQL> create or replace directory test as 'd:\temp';
Directory created
SQL> create or replace directory '6104' as 'd:\temp';
ORA-22929: 无效或遗失的目录名称
上面创建目录的语句说明目录名称如果是数字的,那么一定要用双引号引起来,而不是单引号;如果目录名称是字符形式的则双引号可加可不加。
SQL> grant read,write on directory temp to scott;
ORA-22930: 目录不存在
SQL> grant read,write on directory "temp" to scott;
Grant succeeded
SQL> grant read,write on directory test to scott;
Grant succeeded
上面授权的语句说明创建目录时的目录名称如果加了双引号,则授权时目录名称也要加双引号,否则不用加。删除目录也一样,如下
SQL>drop directory "6104";
Directory dropped
SQL> drop directory "temp";
Directory dropped
SQL> drop directory test;
Directory dropped
--查看创建的目录
SQL> select * from ALL_DIRECTORIES;
OWNER DIRECTORY_NAME DIRECTORY_PATH
------------------------------ ------------------------------ --------------------------------------------------------------------------------
SYS 6104 d:\temp
SYS TEST d:\temp
SYS TEMP d:\temp
SYS temp d:\temp
ORA-22930: 目录不存在
SQL> grant read,write on directory "temp" to scott;
Grant succeeded
SQL> grant read,write on directory test to scott;
Grant succeeded
上面授权的语句说明创建目录时的目录名称如果加了双引号,则授权时目录名称也要加双引号,否则不用加。删除目录也一样,如下
SQL>drop directory "6104";
Directory dropped
SQL> drop directory "temp";
Directory dropped
SQL> drop directory test;
Directory dropped
--查看创建的目录
SQL> select * from ALL_DIRECTORIES;
OWNER DIRECTORY_NAME DIRECTORY_PATH
------------------------------ ------------------------------ --------------------------------------------------------------------------------
SYS 6104 d:\temp
SYS TEST d:\temp
SYS TEMP d:\temp
SYS temp d:\temp
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/27661381/viewspace-1225834/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/27661381/viewspace-1225834/