Re: Alert Log File (UTL

From: Igor Laletin <ilaletin_at_usa.net>
Date: 18 Feb 2004 20:36:44 -0800
Message-ID: <f9226414.0402182036.6f9d0886@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 Wed Feb 18 2004 - 22:36:44 CST

Re: Alert Log File (UTL_FILE)