[20151101]使用dbms_backup_restore删除文件.txt
--dbms_backup_restore自带deletefile过程.使用它可以删除文件.
SCOTT@test> @ver1
PORT_STRING VERSION BANNER
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx 11.2.0.3.0 Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
--建立文件.
$ cat /home/oracle11g/test.txt
this is a test!
--远程以sys用户登录执行如何:
SYS@40> exec dbms_backup_restore.deletefile('/home/oracle11g/test.txt');
PL/SQL procedure successfully completed.
$ ls -l /home/oracle11g/test.txt
ls: /home/oracle11g/test.txt: No such file or directory