728x90

목록UTL_FILE (1)

DBILITY

oracle os file delete ( 오라클에서 os상 file 삭제 )

UTL_FILE Package 중 FREMOVE(PATH,FILE_NM) 를 사용해 봅니다. 아마 9i r2부턴가 지원된다고 합니다. C:\Users\Administrator>sqlplus /nolog SQL*Plus: Release 11.2.0.1.0 Production on Wed Jun 28 14:51:02 2017 Copyright (c) 1982, 2010, Oracle. All rights reserved. SQL> conn /as sysdba Connected. SQL> CREATE DIRECTORY TEST_DIR AS 'D:\\oracle_files'; Directory created. SQL> GRANT READ,WRITE ON DIRECTORY TEST_DIR TO 사용자; Grant..
database/oracle 2017. 6. 28. 14:54
Prev 1 Next
728x90