CREATE [OR REPLACE] DIRECTORY directory AS 'pathname'; 2.目录创建以后,就可以把读写权限授予特定用户,具体语法如下: GRANT READ[,WRITE] ON DIRECTORY directory TO username; 看一个简单的测试: SQL> create or replace directory PIC_FILE_DIR as
create or replace directory BLOBDIR as 'D:\PIC'; grant read,write on directory BLOBDIR to sharedb; GRANT EXECUTE ON utl_file TO sharedb; select * from ALL_DIRECTORIES; 第二步:普通用户登陆,编写存储过程 CREATE OR REPLACE PROCEDURE GET_PIC_BLOB (i_xh VARCHAR2) IS l_file UTL_FILE.FILE_T...
CREATE [OR REPLACE] DIRECTORY DIRECTORY AS 'PATHNAME'; 创建和删除Directory的权限为:CREATE ANY DIRECTORY、DROP ANY DIRECTORY。赋予普通用户使用Directory的权限包括READ、WRITE、EXECUTE,也可以直接写ALL,如下所示: GRANT READ,WRITE,EXECUTE ON DIRECTORY EXP_DIR_LHR TO LHR; GRANT ALL ON DIRECTORY EXP_DIR_...
3.给scott用户赋予在指定目录的操作权限,最好以system等管理员赋予 grant read,write on directory dpdata to scott; 二、导出数据1)按用户导 expdp scott/tiger@orcl schemas=scott dumpfile=expdp.dmp DIRECTORY=dpdata; 2)并行进程parallel expdp scott/tiger@orcl directory=dpdata dumpfile=scott3.dmp parallel=...
UTL_FILE.PUT_LINE写入记录 UTL_FILE.FCLOSE关闭文件 UTL_FILE.FOPEN第一个参数为文件路径,不能直接指定绝对路径,需要建立directory,然后指定我们建立的directory sqlplus / as sysdba create directory MY_DIR as ‘/home/oracle/’; grant read,write on directory dir_dump to HR;##也可以直接建立一个public ...
create directory testdata1 as ‘d:\test\dump’; 4.给xinxiaoyong用户赋予在指定目录的操作权限,最好以system等管理员赋予。 //xinxiaoyong 是用户名(123456是用户密码) grant read,write on directory testdata1 to xinxiaoyong; 5.导出数据 1)按用户导 expdp xinxiaoyong/123456@orcl schemas=xinxiaoyong dum...
Oracle Linux Cloud Service - Version Oracle Linux 5.0 and later: Unable to Write Over a Specific Directory or File in Oracle Linux due to error "Operation not permit
GRANT READ[,WRITE] ON DIRECTORY directory TO username; 例如: grant read, write on directory exp_dir to eygle; 此时用户eygle就拥有了对该目录的读写权限。 让我们看一个简单的测试: 复制 SQL>create or replace directory UTL_FILE_DIR as '/opt/oracle/utl_file';Directory created.SQL>declarefhandle...
is: * <typ>::<file_name:<targetdirectory> * * typ: * O: optional copy if the <file_name is missing, it isignored * M: Mandatorycopy: abort if <file_name> is missing. * E: Executionexecutethe mandatory script <file_name>. * Parameters for script to beexecuted are: *...
GRANT READ,WRITE ON DIRECTORY EXPDIR to 1. 否则执行 create or replace directory expdir as 'E:\bak'; 1. 2 ORA-12154:TNS:无法解析指定的连接标识符 UDE-12154:operation generated ORACLE error 12154 ORA-12154:TNS:无法解析指定的连接标识符 ...