SQL> create or replace directory 6104 as 'd:\temp';

ORA-22929: 無效或遺失的目錄名稱

SQL> create or replace directory "6104" as 'd:\temp';

Directory created

SQL> create or replace directory “temp” as 'd:\temp';

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

UTL_FILE包，將查詢結果寫入檔案

相關文章