Re: How to delete a flat file in SQL

Hi Jonathan,

I enjoyed your book , websites and posts here and on metalink. Do you know if this package is used by RMAN or alternative to RMAN? Thanks,
T Wu

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:<1012155772.16744.0.nnrp-02.9e984b29_at_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 Mon Jan 28 2002 - 09:52:14 CST