UTL_FILE包，将查询结果写入文件
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博客 ” ，链接：https://blog.itpub.net/27661381/viewspace-1225834/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
