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