REPOST: Re: How to delete a flat file in SQL

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 27 Jan 2002 18:24:21 -0000
Message-ID: <0$--$%%%%-_----%-$@news.noc.cabal.int>

In 8.1, there is an undocumented procedure in package dbms_backup_restore called "deletefile", as in:

execute dbms_backup_restore.deletefile('/tmp/temp.txt')

Check $ORACLE_HOME/rdbms/admin/dbmsbkrs.sql before trying it.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Now running 3-day intensive seminars
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases


TP wrote in message <3C4EFA80.6000402_at_infinity.com>...


>Hi smart people,

>

>I read data from a flat file in say c:\tmp and put it in oraclae 8.1.7

>using a procedure and UTL_FILE stuff. Now I want to delete this file

>just using PL/SQL (no c/ java/ c++/ vb etc). How can I do it? Is it even

>possible?

>

>thanks a lot

>

>Tom

>


========= WAS CANCELLED BY =======:
From: "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk>
Control: cancel <1012155772.16744.0.nnrp-02.9e984b29_at_news.demon.co.uk>
Subject: cmsg cancel <1012155772.16744.0.nnrp-02.9e984b29_at_news.demon.co.uk>
Date: Mon, 28 Jan 2002 01:34:38 GMT
X-NNTP-Posting-Host: ltiqvkpr.demon.co.uk:239.65.63.234
X-Trace: news.demon.co.uk 270445442nnrp-17:8186 NO-IDENT ltiqvkpr.demon.co.uk:239.65.63.234
X-Complaints-To: abuse_at_demon.net
Message-ID: <cancel.1012155772.16744.0.nnrp-02.9e984b29_at_news.demon.co.uk>
X-No-Archive: yes
Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server
NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88
Lines: 1         
Path: news.uni-stuttgart.de!cert.uni-stuttgart.de!news.belwue.de!news.uni-ulm.de!rz.uni-karlsruhe.de!blackbush.xlink.net!blackbush.de.kpnqwest.net!newsfeed.vmunix.org!newsfeed.stueberl.de!news-out.cwix.com!newsfeed.cwix.com!news.maxwell.syr.edu!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller
Xref: news.uni-stuttgart.de control:40720274

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers.

Received on Sun Jan 27 2002 - 12:24:21 CST