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: <1012155772.16744.0.nnrp-02.9e984b29@news.demon.co.uk>

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

>

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