- 论坛徽章:
- 0
|
zxh:/home :>ls -lrt
drwxr-xr-- 11 zxh dev 4096 Oct 11 11:24 zxh
zxh:/home/zxh :>l -lrt ora_data.txt
-rwxr-xr-x 1 zxh dev 152 Aug 10 14:36 ora_data.txt
SQL> show user
USER 为 "TEST"
SQL> create or replace directory F_PATH as '/home/zxh';
目录已创建。
SQL> grant read,write on directory F_PATH to public;
授权成功。
SQL> DECLARE
2 IN_FILE UTL_FILE.FILE_TYPE;
3 begin
4 IN_FILE:=UTL_FILE.FOPEN('F_PATH','ora_data.txt','R',2000);
5 UTL_FILE.FCLOSE(IN_FILE);
6
7 end;
8 /
DECLARE
*
第 1 行出现错误:
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 475
ORA-29283: invalid file operation
ORA-06512: at line 4
SQL> select substr(owner,1,10) ,substr(DIRECTORY_NAME,1,10) name ,substr(DIRECTORY_PATH,1,40) path
2 from dba_directories;
SUBSTR(OWNER,1,10) NAME PATH
-------------------- -------------------- ------------------------------------------------------------
SYS ADMIN_DIR /install/ksuriana/050630.0008/withoutsee
SYS DATA_PUMP_ /opt/oracle/oracle10g/rdbms/log/
SYS WORK_DIR /install/ksuriana/050630.0008/withoutsee
SYS F_PATH /home/zxh |
|