20151101使用dbms_backup_restore删除文件

[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