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