good call.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Igor Laletin" <ilaletin_at_usa.net> wrote in message
news:f9226414.0402182036.6f9d0886_at_posting.google.com...
> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:<403222ea$0$7063$ed9e5944_at_reading.news.pipex.net>...
> > As far as appending to the table goes, this procedure works by dumping
the
> > data into an table and then renaming the alert log file.
>
> It's a bit better to rename file first and load it after that. This
> way you are not loosing anything might has been added to the file
> between 'exit loop' and 'utl_file.frename'.
>
> Regards,
> Igor
>
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
Received on Thu Feb 19 2004 - 00:52:19 CST
